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 “gaiters” with Change Limit: [1] [2]

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

141 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
gaiters8351654(None) 
baiters94619301baiters
gainers84214591gainers
gaiter73819501gaiter_
garters84218231garters
gasters85624291gasters
gaters74728641ga_ters
goiters84014441goiters
waiters104218621waiters
afters94717072_afters
aiders74524632_aiders
aimers84621912_aimers
airers64922312_airers
aivers94822322_aivers
alters64924222_alters
asters65631602_asters
awaiters1146642awaiters
bailers94221352bailers
baiter84422552baiter_
banters94623112banters
barters94223032barters
basters94930302basters
batters94626012batters
biters83925242_biters
canters94827732canters
carters95327252carters
casters94729902casters
caters85336502ca_ters
citers85022982_citers
daikers124010312daikers
darters84017602darters
daters74827372da_ters
easters75125682easters
eaters65535952ea_ters
fainters11349692fainters
falters103916472falters
gabbers124612832gabbers
gadders103611502gadders
gaffers14428712gaffers
gagers84021332ga_gers
gaggers103413662gaggers
gagsters10317082gagsters
gainer74117492gainer_
gaited84416922gaite_d
gaits65726012gait__s
gamers94420832ga_mers
gammers123214562gammers
ganders93521702ganders
gangers94418602gangers
ganisters10248312ganisters
gaolers83511562gaolers
gapers94520472ga_pers
garners83815982garners
garter74420512garter_
gaspers105014132gaspers
gassers84714632gassers
gaster75027352gaster_
gater64533652ga_ter_
gates65939512ga_te_s
gathers114315072gathers
gators74115832ga_tors
gaugers94211712gaugers
gawkers15347452gawkers
gawpers13448312gawpers
gazers164516302ga_zers
getters84216102getters
gibers95114662g_ibers
gites65630182g_ite_s
givers104817712g_ivers
gliders94811842gliders
glisters93912602glisters
glitters93710542glitters
goiter74116202goiter_
goitres8389562goitres
grafters12409192grafters
grainers93012072grainers
granters93614142granters
graters85419742graters
grifters12389232grifters
gripers104011462gripers
gristers94013402gristers
gritters94210632gritters
guiders94111112guiders
guitars8116862guitars
gutters83715512gutters
hafters134614332hafters
hailers104017262hailers
halters104619802halters
haters94930402ha_ters
hatters104221522hatters
igniters9126232igniters
jailers144114042jailers
kaisers11369272kaisers
kiters105218592_kiters
lasters75627692lasters
liters65429882_liters
loiters74116612loiters
mailers94420332mailers
maimers113813042maimers
masters94628922masters
maters85032392ma_ters
matters94421752matters
miters84328782_miters
nailers73215892nailers
natters73718062natters
niters64624212_niters
oaters65029792oa_ters
painters103013022painters
palters94021682palters
pasters94531732pasters
paters84935832pa_ters
patters94825192patters
plaiters103512632plaiters
rafters103715632rafters
raiders84615142raiders
railers74420662railers
raisers73617392raisers
ranters73323642ranters
rasters74629022rasters
raters63936582ra_ters
ratters74422472ratters
sailers73822322sailers
salters73622252salters
smiters93414362smiters
suiters73618882suiters
tailers73720182tailers
tasters74225642tasters
taters64932202ta_ters
tatters74520482tatters
titers64526412_titers
uniters73814172uniters
wafters134112812wafters
wailers103916802wailers
waisters113811522waisters
waiter94321252waiter_
waivers133410052waivers
wanters104420092wanters
wasters104026592wasters
waters95030632wa_ters
writers105513492writers
yatters103914622yatters

Search took 4 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 Filter1786911076710.376475242.0
2DLD Change Limit1076711412.90337089.6
3Display Results1411410.0463065.2
 (SQL Overall)1786911413.32553741.7
 
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.