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

305 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
gateless927995(None) 
dateless9259961dateless
grateless10277581grateless
mateless102711291mateless
ageless8310342_ageless
aweless1038722_aweless
baseless1099562baseless
bathless13127382bathless
careless102813632careless
cateress102311612cateress
faceless13269172faceless
fadeless12258322fadeless
fameless13259202fameless
fatless103212202fat_less
gainless9117402gainless
gameness112810692gameness
gapless10349992ga_pless
garbless11388252garbless
gasless8319012ga_sless
graceless12226892graceless
gradeless11236702gradeless
graveless13226692graveless
gutless82610712gut_less
hatless103813442hat_less
laceless10239852laceless
lateness82614072lateness
maneless102812342maneless
matless93014042mat_less
nameless10248372nameless
natheless1244962natheless
nathless11127022nathless
noteless839402noteless
paneless102611762paneless
pathless13138042pathless
stateless937562stateless
tameless10259902tameless
tapeless10218642tapeless
tasteless935672tasteless
voteless1137492voteless
wageless1237172wageless
wakeless1536472wakeless
waterless1238012waterless
wattless11268722wattless
waveless1437482waveless
abeles84719393_abele_s
aidless83612073_aidless
aimless93610813_aimless
airless73712043_airless
aneles64626293_anele_s
armless9369943_armless
artless73712513_artless
ashless10318453_ashless
ateliers837883_ateliers
awless939263_a_wless
awnless1035923_awnless
backless162910633backless
badgeless1343203badgeless
barbless12318713barbless
bareness10912813bareness
barkless14318023barkless
barless94317003ba_rless
baseness10910943baseness
battlers104110973battlers
battles94517683battle_s
beatless103311593beat_less
bladeless1234303bladeless
blameless1334733blameless
boneless10310213boneless
brakeless1544993brakeless
capelets1268603capelets
capless114312763ca_pless
carless95118493ca_rless
cashless1336773cashless
caterers102814403caterers
causeless1135193causeless
ceaseless1135733ceaseless
clueless1035883clueless
coatless1039693coat_less
codeless112010113codeless
coreless103013833coreless
cureless10319703cureless
cuteness1039673cuteness
datedness1187753datedness
deathless1335223deathless
earless74316073ea_rless
edgeless1034883edgeless
eyeless1058053_eyeless
faithless1543903faithless
fangless1237663fangless
fatalness1245773fatalness
fatherless1644213fatherless
fatness103311293fat_ness
feeless103511103_feeless
feetless1137383feetless
fireless112810593fireless
flameless1435353flameless
frameless1435533frameless
fretless1138063fretless
fumeless13236603fumeless
fuseless11237233fuseless
gabblers134110083gabblers
gabbles124415413gabble_s
gabelles11278933gabelles
gables94222333ga_ble_s
gaggles103512593gaggle_s
galeas74618513ga__leas
galeres83514333galere_s
gales65442483ga__le_s
galilees936333galilees
galleass935053galleass
gallets83517403ga_llets
galleys11369713ga_lleys
gamblers13369733gamblers
gambles124016203gamble_s
gamelans11115843gamelans
gametes10312253gamete_s
gaminess112911063gaminess
gantlets9308903gantlets
gaolers83511563ga_olers
garblers113810283garblers
garbles104016923garble_s
garglers10418263garglers
gargles94214893gargle_s
gaseliers1044923gaseliers
gastness9278473gastness
gateaus866333gate_aus
gatelike1337933gatelike
gatemen1047603gateme_n
gatepost1145443gatepost
gateposts1243103gateposts
gaters74728643gat__ers
gates65939513gat__e_s
gateways1544613gateways
gatherers13156883gatherers
gathers114315073gat_hers
gaveled12399133gavele_d
gavels105911093gavel__s
gayness1136843ga_yness
gazelles18266563gazelles
gearless937373gearless
gelees74116263g__elees
giftless1245173giftless
glandless1134163glandless
glassless1043873glassless
glebeless1242953glebeless
goalless935723goalless
goatees82710443goate_e_s
godless938403g_odless
goneness9310763goneness
gormless11235443gormless
grainless1035893grainless
grassless1034303grassless
graveness13288383graveness
greaseless1143483greaseless
greedless1144893greedless
groveless13235363groveless
gruelers936173gruelers
guideless1143843guideless
guileless1044253guileless
gumless10228273g_umless
gunless8299633g_unless
gustless9287683gustless
guttlers9306933guttlers
guttles83011933guttle_s
hairless1157413hairless
haleness11312623haleness
haltless11308443haltless
handless123512063handless
hapless123311333ha_pless
harmless1337403harmless
heathless1535593heathless
heatless113011463heat_less
hideless12278713hideless
hitless103211193hit_less
hiveless14227933hiveless
holeless1189363holeless
homeless131110133homeless
hopeless13118303hopeless
hueless1058823_hueless
iceless9219963_iceless
irateness9310493irateness
ireless72312243_ireless
isleless834853isleless
jagless1537103ja_gless
jawless1745653ja_wless
kanteles1238123kantele_s
labelers10249413labelers
lameness102612673lameness
landless94011173landless
lateens74210553late_ens
latexes1438313latexe_s
lawless1037033la_wless
lifeless11228143lifeless
limeless10249663limeless
lineless82711943lineless
liteness82213213liteness
loveless1168573loveless
mailless10248583mailless
maleness10312313maleness
manless93012933ma_nless
mantelets1176813mantelets
massless10277113massless
mastless102610023mastless
matchless1644683matchless
matelasse1163083matelasse
matelots1047533matelots
mateyness1444473mateyness
matiness102114753matiness
mattress1036533mattress
meatless103410863meat_less
moveless1367753moveless
muteness1039013muteness
napless93110283na_pless
netless739863net_less
noseless839513noseless
oarless73913373oa_rless
outbless1037963outbless
painless10108343painless
paleness10312983paleness
paperless1345833paperless
passless10247223passless
pastless102411203pastless
patellas1039103patellas
patness92912283pat_ness
pileless1088623pileless
pipeless12107663pipeless
pithless13117023pithless
pitiless10127333pitiless
placeless1335613placeless
platelets1165763platelets
poetless1038723poetless
poleless1089873poleless
popeless1288473popeless
rainless8129703rainless
rankless12268233rankless
rareness81112853rareness
ratels64518213ratel__s
rattlers83510293rattlers
rattles73217303rattle_s
ravelers113310863ravelers
rayless10239003ra_yless
ruleless836633ruleless
ruthless1135413ruthless
safeness11239633safeness
sageness92111983sageness
sailless82410373sailless
saltless8259343saltless
sameness102712683sameness
sandless93212343sandless
saneness82313723saneness
sapless93313443sa_pless
sashless1136603sashless
sateens73710753sate_ens
scaleless1135513scaleless
scatheless1542923scatheless
seatless83213003seat_less
shadeless1335733shadeless
shameless1435923shameless
shapeless1435563shapeless
shoeless1137803shoeless
soleless8910033soleless
spaceless1335733spaceless
starless81610843starless
steles63725663_stele_s
stemless1036653_stemless
tableless1145033tableless
tackless14419483tackless
tactless10288463tactless
tailless8239083tailless
tameness102411253tameness
tankless12267823tankless
tattlers8369693tattlers
tattles73616283tattle_s
taxless1436913ta_xless
teles54536003__tele_s
teleses7313123__teleses
telesis7310793__telesis
tideless9269083tideless
tieless72512563_tieless
timeless10239543timeless
tireless82510263tireless
toeless72612393_toeless
toneless8610393toneless
traceless11228643traceless
treeless839283treeless
tubeless1037023tubeless
tuneless837913tuneless
useless7188423_useless
valueless1242843valueless
valveless1543163valveless
viceless1337983viceless
waeness102512783wa_eness
wardless12249303wardless
warless104015103wa_rless
wartless11279923wartless
waterers112312783waterers
wattles103814073wattle_s
wavelets1436153wavelets
wayless13308243wa_yless
wifeless14277483wifeless
wineless112711173wineless
wireless11249633wireless
witless103310983wit_less
yokeless1535303yokeless
zoneless1737823zoneless

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 Limit1461623057.62319173.8
3Display Results3053050.1262420.6
 (SQL Overall)1786913057.90522604.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.