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

180 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
gluts6612013(None) 
glouts74414711glouts
glues65125681glues
glugs75214281glugs
glums84621421glums
glut56331291glut_
glute66020901glute
glutes74517671glutes
gouts64826171gouts
guts56637251g_uts
sluts54523981sluts
abuts75417072abuts
aglets73915682aglets
alts46639902al_ts
alums75720602alums
bhuts105812952bhuts
blats75132502blats
blets75324942blets
blots75626172blots
blubs95818152blubs
blues75127042blues
bluets87215492bluets
blunts84512892blunts
blurs74619082blurs
blurts84412642blurts
bouts75131312bouts
bruts75922952bruts
buts67247692_buts
clots75627642clots
clouts87017202clouts
clubs95415102clubs
clues74623032clues
cults75022552cults
cuts65841152_cuts
dauts67822242dauts
elute54822572elute
elutes64020312elutes
engluts834532engluts
flats86429742flats
flits85625222flits
flouts94315272flouts
flubs105515442flubs
flues84626922flues
flus75626542flu_s
flute86823752flute
flutes95421782flutes
fluty114415642fluty
fluyts12367152fluyts
gaits65726012gaits
gamuts958782gamuts
gasts66628632gasts
gats56753442g_ats
gauds75717722gauds
gaults74112782gaults
gaums86217072gaums
gaurs66317992gaurs
gauss65613452gauss
gelts65924612gelts
gents65729612gents
gests66028812gests
gets55442482g_ets
geums85414112geums
ghats95818612ghats
ghauts10447782ghauts
gifts96214962gifts
gilts64924262gilts
girts65423622girts
gists66026192gists
gits55744592g_its
glads75620612glads
glams85822932glams
glans65125832glans
glass65518132glass
gleds75417892gleds
glees65027592glees
gleets75315052gleets
glens66519852glens
gleys96514852gleys
glias64618492glias
glims87417672glims
glints75714212glints
glitz154916372glitz
gloats74515422gloats
globs85616402globs
gloms85219782gloms
glops85619552glops
gloss64319622gloss
glost65422932glost
glosts74513812glosts
glout65925812glout_
glows95518032glows
glue55628492glu_e
glued75118362glued
gluer65116772gluer
gluers75011152gluers
gluey95715262gluey
glug66118012glu_g
glum75825102glu_m
glume85120462glume
glumes94516812glumes
gluon6311222gluon
gluons738502gluons
glutei7409742glutei
gluten74210752gluten
glutens8437592glutens
gluteus8386252gluteus
gnats65217712gnats
gnus56518002gnu_s
goats65527302goats
gout56646002gout_
gouty95217362gouty
grits65529582grits
grots65025852grots
grouts75015612grouts
grubs86312602grubs
grues65721962grues
grunts75511852grunts
gules64831042gules
gulfs94915302gulfs
gulls65222982gulls
gulps84715072gulps
guls55930852g_uls
gums75030942g_ums
guns55533482g_uns
gust55240702g_ust
gusts65722792gusts
gut46753852g_ut_
gutsy96412842g_utsy
guvs85816812g_uvs
guys85019642g_uys
huts76737442_huts
iglus6609932iglu_s
juts115930162_juts
klutz1868852klutz
lats45962702_lats
lets47147942_lets
lits46252492_lits
lots47652092_lots
louts56330272louts
lues45943552_lues
lugs55233522_lugs
lums65734242_lums
lunts55826902_lunts
lust47442602_lust
lusts55022802_lusts
lute46341012_lute
lutes55836662_lutes
lutz136826322_lutz
luvs75818502_luvs
mauts75927192mauts
muts64839982_muts
nuts45032672_nuts
outs45746962_outs
phuts104613502phuts
plats75531372plats
plots75025672plots
plugs85213492plugs
plums94619952plums
plus66324832plu_s
pouts75530322pouts
puts65641752_puts
routs57133412routs
ruts44541492_ruts
scuts74522522scuts
shuts85622482shuts
slats55436902slats
slits56128852slits
slots54830532slots
slubs74719532slubs
slues54527172slues
slugs64618562slugs
slums74623432slums
slurs54123372slurs
slut45040592slut_
smuts75415712smuts
tauts56125512tauts
touts54830392touts
tuts45838452_tuts
ulus45622562ulu_s
uts35534372__uts

Search took 2 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 Filter178691538000.296603685.8
2DLD Change Limit538001801.51635488.1
3Display Results1801800.0632857.1
 (SQL Overall)1786911801.87595301.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.