Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “leftish” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

157 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
leftish1319725(None) 
leftism12226091leftism
leftist10279351leftist
elfish1267962elf_ish
fetish12310372fe_tish
latish92416172l_atish
leftest10269462leftest
lefties10312072lefties
leftisms13235242leftisms
leftists11235512leftists
lefts86517812left_s_
lentisk1136062lentisk
loutish1039962loutish
pettish1238282pettish
softish13127812softish
wettish1335962wettish
batfish1558683batfish
beamish14259293beamish
bearish123013273bearish
beauish12268513beauish
befits114711503befits_
betise85616273be_tise
bleakish1745053bleakish
blemish1436603ble_mish
bluefish1645143bluef_ish
brutish1237703brutish
catfish1559023catfish
cattish12410723cattish
clefting14347583clefting
clefts114610163cleft_s_
clerkish1744263clerkish
coltish121310933coltish
cultish12139113cultish
deafish1438533deafish
defis96717503def_is_
deftest112611713deftest
delish105215613de_lish
dentist8316743dentist
dervish1436983dervish
doltish11118733doltish
efts76519483_eft_s_
elitism939763elitism
elitist7414913elitist
elvish1277563_elvish
fattish1359263fattish
fetich1479693fe_tich
fiftyish2042553fiftyish
filefish1745593filef_ish
fish106926273__f_ish
flatfish1744933flatfish
flattish1455263flattish
flemish1536373fle_mish
goatish1139563goatish
heftier1337203heftier
heftiest1439183heftiest
heftily1635763heftily
hefting144510913hefting
hefts116218153heft_s_
heimish1535463heimish
hellish13310723hellish
hennish1336863hennish
hottish13117903hottish
huffish1935713huffish
ileitis738063ileitis_
jewfish2343543jewfish
laddish12299723laddish
ladyish14287823ladyish
largish1138603largish
larkish1439083larkish
lavish124112983l_avish
lazyish22265853lazyish
leash85519213le__ash
lectin82515013lecti_n
lectins92515003lectins
lection92614863lection
leets54927123leet_s_
left76340483left___
lefter93613433left_er
leftmost1342583leftmost
leftwing1532973leftwing
lefty115613563left__y
legist71315253le_gist
legits71313003legits_
leis45739603le__is_
lemonish1347323lemonish
lenis56326863le_nis_
lentic83515743lenti_c
lentigo846063lentigo
lentil64315393lenti_l
lentils73912973lentils
lentisks1244413lentisks
lentos65317403lentos_
leptin82512333lepti_n
leptins92412693leptins
letch105215803le_t_ch
lets47147943le_t_s_
letting83218533letting
levis85818553le_vis_
lewis85315843le_wis_
lexis125916033le_xis_
lifting113313273lifting
lifts85719063lift_s_
lightish1556623lightish
littlish1145043littlish
loftier1037763loftier
loftiest1139083loftiest
loftily1336353loftily
lofting113311313lofting
lofts85518363loft_s_
loggish12258733loggish
longish11229093longish
loudish1137983loudish
lowish12310533l_owish
lumpish14127383lumpish
lutfisk1443583lutfisk
lutist64317553l_utist
metis75025903me_tis_
muftis1158053muftis_
nebbish1444253nebbish
nerdish1137103nerdish
newish1237903ne_wish
oafish121311723oaf_ish
offish15137273_offish
outfish132210573outfish
peakish16268873peakish
peckish18227293peckish
peevish1535783peevish
perish114619063pe_rish
perkish16258823perkish
plenish1239943ple_nish
raffish1658843raffish
ratfish1338773ratfish
rattish10510823rattish
reddish1238033reddish
redfish1437793redfish
refinish1447893refinish
refits94017653refits_
refresh1335453refresh
relish93916953re_lish
runtish1048693runtish
ruttish1048303ruttish
saltish10312163saltish
selfish1388513selfish
serfish1348973serfish
sluttish1145443sluttish
sottish10129443sottish
sweetish1445373sweetish
tartish101512633tartish
testis64916713testis_
tilefish1445453tilef_ish
weakish17217173weakish
wearish132310153wearish
wefts116715493weft_s_
weftwise1741813weftwise
wennish1336243wennish
whitish1635973whitish
yetis85418393ye_tis_

Search took 7 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911340270.406440125.6
2DLD Change Limit1340271576.34321129.9
3Display Results1571570.0463413.0
 (SQL Overall)1786911576.79526297.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.