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

281 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
flyless133500(None) 
fatless103212202fatless
feeless103511102feeless
feyness1334922feyness
filmless1344552filmless
finless102810782finless
flagless1235402flagless
flapless1335342flapless
flawless1434502flawless
flyers125712802fly_ers
flyleaf1642582flyleaf
flytes123911562flyte_s
fogless1138192fogless
furless103210142furless
joyless17226512joyless
keyless1436162keyless
playless1334862playless
rayless10239002rayless
slyness1035262slyness
toyless10268712toyless
wayless13308242wayless
ageless8310343ageless
aidless83612073aidless
aimless93610813aimless
airless73712043airless
allees64521483al_lees
alleys95113303al_leys
armless9369943armless
artless73712513artless
ashless10318453ashless
aweless1038723aweless
awless939263_awless
awnless1035923awnless
barless94317003barless
bedless1039703bedless
beltless10297713beltless
bibless11439173bibless
bless75917813__bless
blotless10347153blotless
blypes13357543blype_s
boltless10338283boltless
bowless123310313bowless
braless92910563braless
budless1038873budless
capless114312763capless
carless95118493carless
chyles144813283chyle_s
clawless1334123clawless
clueless1035883clueless
clypeus1433243clypeus
coxless1637743coxless
coyness1277323coyness
dewless1137473dewless
doyleys14384923doyleys
dryness11114783dryness
earless74316073earless
eggless935663eggless
egoless836983egoless
eldress835003eldress
endless839833endless
eyeless1058053eyeless
fablers124812613fablers
fables114921673fable_s
faceless13269173faceless
fadeless12258323fadeless
fallers103917993fallers
fameless13259203fameless
fangless1237663fangless
farles96025783farle_s
farness102912203farness
fatness103311293fatness
faultless1243163faultless
fearless1137873fearless
feckless17225783feckless
feelers103814743feelers
feetless1137383feetless
fellers104117543fellers
fellest10313753fellest
fellness1135913fellness
fernless1136063fernless
fess76529163f___ess
fewness1335003fewness
feyest12311403fey_est
filers94623723f_ilers
files85441273f_ile_s
filets94718953f_ilets
fillers104320213fillers
filles94224523fille_s
fillets103414753fillets
fireless112810593fireless
fishless1436413fishless
fitness10299393fitness
flakers143613273flakers
flakes134118873flake_s
flameless1435353flameless
flamens124611063flamens
flamers124616363flamers
flames114723693flame_s
flanes94522423flane_s
flares94521703flare_s
flatlets1147373flatlets
flatness1138153flatness
flaxes165015353flaxe_s
flayers133912033flayers
fleas86423663f__leas
fleckless1842893fleckless
fleers96015793fl_eers
flees85828753f__lees
fleets96915063fl_eets
flenses1039473flenses
flesh115013743f__lesh
fleshless1543993fleshless
flews115316443f__lews
flexes164512953flexe_s
fleys117015603f__leys
fliers94417193fl_iers
flies85630713fl_ie_s
fliest94718433fl_iest
flites95122443flite_s
flockless1843163flockless
floes85528143fl_oe_s
floorless1243793floorless
florets1039853florets
floss85118263f__loss
flosses103411973flosses
flourless1243533flourless
flowers133413173flowers
flues84626923fl_ue_s
flukes135114193fluke_s
flumes115119733flume_s
fluters103713683fluters
flutes95421783flute_s
fluxes165212933fluxe_s
flybelt1594453flybelt
flybelts1682753flybelts
flyblew1841403flyble_w
flyblows1942013flyblows
flyboys18112943flyboys
flybys1792773fly_bys
flyer114916253fly_e_r
flyings14496063flyings
flyleaves1841263flyleaves
flymen14387773flyme_n
flyoffs1542253flyoffs
flyovers1733673flyovers
flypast1583753flypast
flypasts1662433flypasts
flyte115713943flyte__
flyted13378773flyte_d
flytiers14254483flytiers
flyways19133853flyways
foamless13195843foamless
foleys123810463f_oleys
folles93820473folle_s
foodless12338383foodless
footless113710803footless
fordless12289003fordless
forkless15267433forkless
formless13248083formless
foulest10313313foulest
foulness11236653foulness
fowlers133411203fowlers
foyers125413133foy_ers
fretless1138063fretless
fryers125710973fry_ers
fuelers103912393fuelers
fugles104715783fugle_s
fullers103817373fullers
fullest10313343fullest
fullness1135443fullness
fulness10248963fulness
fumeless13236603fumeless
furlers104214223furlers
fuseless11237233fuseless
fyces139813643f_yce_s
fykes156312693f_yke_s
gapless10349993gapless
gasless8319013gasless
gayness1136843gayness
godless938403godless
gumless10228273gumless
gunless8299633gunless
gutless82610713gutless
haltless11308443haltless
hapless123311333hapless
hatless103813443hatless
helmless1334273helmless
helpless1335063helpless
hiltless11297123hiltless
hipless12399923hipless
hitless103211193hitless
holeless1189363holeless
hoyles12315013hoyle_s
hueless1058823hueless
iceless9219963iceless
illest63615723il_lest
illness736473illness
inkless11348713inkless
innless7288293innless
ireless72312243ireless
isleless834853isleless
jagless1537103jagless
jawless1745653jawless
jobless16237563jobless
juryless1832983juryless
kayles134712003kayle_s
kinless113310273kinless
lawless1037033lawless
legless838013legless
less45635103___less
lidless8309273lidless
lipless9259553lipless
loess55714703_l_oess
lyases95211873_lyases
lycees11428863_lycees
lyes75530833_ly_e_s
lyres85019963_lyre_s
lyses84518253_lyse_s
manless93012933manless
matless93014043matless
milkless1434773milkless
napless93110283napless
netless739863netless
oarless73913373oarless
odyles10348563odyle_s
oldness836403oldness
orbless937493orbless
pegless1038053pegless
peltless10267373peltless
phyleses1645183phyleses
phylesis1645313phylesis
pileless1088623pileless
planless1036813planless
playlets1334903playlets
plotless10256793plotless
plugless1133863plugless
plyers114912983ply_ers
poleless1089873poleless
pulpless12224953pulpless
ribless93410343ribless
rimless9369363rimless
rodless8310073rodless
ruleless836633ruleless
runless72810423runless
saltless8259343saltless
sapless93313443sapless
selfless1135013selfless
sexless1467243sexless
shyness1344993shyness
sinless73014213sinless
slipless10246993slipless
slitless8268143slitless
slyest93811363sly_est
slypes114410483slype_s
soleless8910033soleless
sonless72612613sonless
stylers10359353stylers
styles94418653style_s
stylets10369213stylets
sumless92611123sumless
sunless73013693sunless
taxless1436913taxless
tieless72512563tieless
tipless92610063tipless
toeless72612393toeless
topless92511123topless
tugless837383tugless
unless62413073_unless
useless7188423useless
vowless13246603vowless
warless104015103warless
webless1237003webless
weldless12285813weldless
wigless11359673wigless
winless103212283winless
witless103310983witless
wryness13113983wryness
wyles114615323_wyle_s
xylems1833203_xylems
ylems1039263__ylems
zipless18276303zipless

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.393454684.5
2DLD Change Limit1340272815.61023890.7
3Display Results2812810.0933021.5
 (SQL Overall)1786912816.09629312.8
 
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.