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 “cropless” 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.

258 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
cropless123779(None) 
browless1346652browless
capless114312762c_apless
cookless14258632cookless
cordless11299962cordless
coreless103013832coreless
coxless1637742c_oxless
crewless1335402crewless
croppers143311482croppers
crownless1443422crownless
dripless1135242dripless
droplets1136062droplets
hoopless13279252hoopless
rodless8310072_rodless
topless92511122_topless
armless9369943ar_mless
armorless1143483armorless
arrowless1242803arrowless
artless73712513ar_tless
blotless10347153blotless
boonless10328353boonless
bootless103410983bootless
bowless123310313_bowless
braless92910563br_aless
brimless1235273brimless
broilers103210093broilers
broodless1235033broodless
caplets114914523c_aplets
carbonless1444083carbonless
careless102813633careless
carless95118493c_arless
carolers103314173caro_lers
carollers1137703carollers
cashless1336773cashless
chadless1436403chadless
chaplets1556883chaplets
chinless1337493chinless
cholers124215203cho_lers
choppers174110463choppers
clawless1334123clawless
cloudless1243153cloudless
clueless1035883clueless
coalers94419353c_oalers
coalless1038193coalless
coatless1039693coatless
cobles104622883c_oble_s
codeless112010113codeless
coilers93619903c_oilers
coles76055063c_o_le_s
coleus86818273c_o_leus
collets93517903c_ollets
colorless1145683colorless
compress1439053compress
confess12399903c_onfess
coolers93522493c_oolers
coolest9318643c_oolest
coolness1037743coolness
coopers114019483coop_ers
copens106119963c_op_ens
copers104629843c_op_ers
copes97747103c_op_e_s
copiers114215963c_opiers
copies104130303c_opie_s
coplots11511593c_oplots
coppers133519753c_oppers
copses104922473c_opse_s
copters113621283c_opters
corpses113913803corpse_s
corpuses12310063corpuses
corslets1038273corslets
corulers1039773corulers
costless10310003costless
coulees9315503c_oulees
couplers123311323couplers
couples115317053couple_s
couplets12389873couplets
coyness1277323c_oyness
cradlers11309203cradlers
cradles103114133cradle_s
crapes104727693crap_e_s
crappers144011023crappers
crawlers13309003crawlers
creoles9913323creole_s
crepes105419343crep_e_s
crepiest12310383crepiest
cress75022833cr___ess
crestless1146783crestless
crimeless1335063crimeless
crimples14308963crimple_s
cripes105120873crip_e_s
cripplers15314993cripplers
cripples14298403cripple_s
crispness1345303crispness
croakers14288523croakers
crochets15359833crochets
crockets16339543crockets
crocuses1239023crocuses
crofters13358903crofters
cromlech1742053cromlech
cromlechs1841563cromlechs
crones84729243cro_ne_s
cronies9622503cronie_s
crookest1436683crookest
crooners103911393crooners
cropland1346303cropland
croplands1445373croplands
cropped143812063croppe_d
cropper133312963croppe_r
croppies143111133croppies
crops96125233crop___s
croquets1955213croquets
crores86121163cro_re_s
crosiers103312063crosiers
cross75124503cro___ss
crossers103912703crossers
crosses94220793crosse_s
crossest1012012123crossest
crosslets1145183crosslets
crossness1137093crossness
croupes114613103croupe_s
croupiers1334653croupiers
croupiest1337063croupiest
croutes94815653croute_s
crowders14398803crowders
crowers124614893cro_wers
crowners133710743crowners
crownets13407673crownets
crozers184111083cro_zers
crozes174417663cro_ze_s
croziers19287003croziers
cruelest1059183cruelest
cruelness1145053cruelness
crullers1047303crullers
crumples14348813crumple_s
cruppers14317323cruppers
crustless1155403crustless
cuffless1634293cuffless
cureless10319703cureless
cypress1434653c_ypress
doorless936713doorless
drollest937353drollest
drollness1043623drollness
droplet10312113drople_t
droppers13318603droppers
echoless1345603echo_less
egoless836983ego_less
errorless942813errorless
flapless1335343flapless
fogless1138193_fogless
foodless12338383foodless
footless113710803footless
fordless12289003fordless
forkless15267433forkless
formless13248083formless
fretless1138063fretless
frockless1843453frockless
froglets1235263froglets
frontless1235403frontless
frostless1235743frostless
gapless10349993_gapless
godless938403_godless
gormless11235443gormless
gropers104813853grop_ers
gropes95220403grop_e_s
groveless13235363groveless
growlers12327093growlers
hapless123311333_hapless
helpless1335063helpless
hipless12399923_hipless
hoodless12289733hoodless
hoofless14258013hoofless
hookless151238363hookless
hopeless13118303_hopeless
hornless1137363hornless
humpless15226333humpless
ireless72312243ir_eless
ironness836953ironness
jobless16237563_jobless
joyless17226513_joyless
knotless1264563knotless
lipless9259553_lipless
lordless9277483lordless
moonless10278043moonless
napless93110283_napless
normless10235923normless
odorless934173odorless
orbless937493or_bless
peoplers1237153peoplers
peoples11312213people_s
plotless10256793plotless
popeless1288473_popeless
portless10310643portless
prebless1236823prebless
prepress12137983prepress
problems1434343problems
process11310403pro_cess
profess1237713pro_fess
progress1137023progress
prolegs10379993pro_legs
proles84627203pro_le_s
propels113412843prop_els
propers113619033prop_ers
prophesy1844453prophesy
prophets1539503prophets
propjets1935493propjets
proposes122515973proposes
prowess1237903pro_wess
prowlers13328933prowlers
pulpless12224953pulpless
pumpless14236373pumpless
rayless10239003_rayless
repress92712683_repress
ribless93410343_ribless
rimless9369363_rimless
roadless937703_roadless
robles85321693_roble_s
rockless14297293_rockless
roles56747983_ro_le_s
rollers73117473_rollers
roofless11316733roofless
rootless83910443rootless
ropers84325903_rop_ers
ropes75940063_rop_e_s
ropiest93317773_ropiest
ropiness102311073_ropiness
rumpless12256543rumpless
runless72810423_runless
sapless93313443_sapless
scoreless1155603scoreless
scruples1237433scruple_s
shipless13277693shipless
shoeless1137803shoeless
slipless10246993slipless
smogless1134053smogless
snapless10287463snapless
snowless1145623snowless
soapless10278073soapless
sonless72612613_sonless
soupless10268463soupless
spotless1037043spotless
strapless1135793strapless
thowless1434613thowless
tipless92610063_tipless
toeless72612393_toeless
toolless836343toolless
toyless10268713_toyless
tramless1037503tramless
treeless839283treeless
triples94616873triple_s
triplets103510263triplets
trollers83211213trollers
trolleys11315693trolleys
tropes84824353trop_e_s
vowless13246603_vowless
woodless12278453woodless
wordless12258843wordless
workless15276803workless
zipless18276303_zipless

Search took 8 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 Filter1786911461620.1561145455.1
2DLD Change Limit1461622587.62619166.3
3Display Results2582580.0932774.2
 (SQL Overall)1786912587.87522690.9
 
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.