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

131 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
suiters7361888(None) 
smiters93414361smiters
suiter64121811suiter_
suites63727401suite_s
suitors73012491suitors
baiters94619302baiters
biters83925242_biters
bruiters10329142bruiters
bunters94717122bunters
busters94724132busters
butters94521722butters
citers85022982_citers
cutters94218962cutters
duikers12369382duikers
dusters84918362dusters
fruiters11328182fruiters
gaiters83516542gaiters
goiters84014442goiters
guiders94111112guiders
guitars8116862guitars
gutters83715512gutters
hunters103915732hunters
hurters103413642hurters
juicers1636152juicers
justers143815732justers
kiters105218592_kiters
liters65429882_liters
loiters74116612loiters
lusters73921442lusters
miters84328782_miters
musters94522512musters
mutters94117142mutters
niters64624212_niters
nutters74215432nutters
ousters74122792ousters
outers64230172ou_ters
punters93617042punters
putters94219192putters
quieters17248732quieters
quilters17228432quilters
quitters17238522quitters
quivers19298752quivers
quoters16369262quoters
ruiners74213022ruiners
sailers73822322sailers
salters73622252salters
saunters82911752saunters
scoters93313812scoters
scutters103311022scutters
seaters74028942seaters
seiners74219272seiners
seisers73816392seisers
seizers164112502seizers
setters73822062setters
shiers94921752shi_ers
shifters14319862shifters
shiners104015942shiners
shivers133714832shivers
shunters113210752shunters
shutters113611352shutters
sifters103714792sifters
sinters74024082sinters
sisters73721592sisters
sitars65417592s_itars
sites56045432s_ite_s
sitters74221552sitters
sivers95324152s_ivers
sizers155215812s_izers
skaters113512962skaters
skiers104713702ski_ers
skirters12337242skirters
skites104418042skite_s
skitters12349552skitters
skivers14409702skivers
slaters73123732slaters
slicers94114922slicers
sliders83515222sliders
slithers114212952slithers
slitters84014132slitters
slivers104115252slivers
smilers94113852smilers
smiter83616412smiter_
smites83921922smite_s
smithers13369792smithers
snifters11318612snifters
snipers93311772snipers
sorters74221132sorters
souters74422602souters
spicers113815552spicers
spiders103914412spiders
spiers84421742spi_ers
spikers135311992spikers
spites84127332spite_s
spitters104113382spitters
spurters103311702spurters
sputters104012872sputters
squinters1835522squinters
squirters1835072squirters
staters73922342staters
stinters83312752stinters
stivers103613542stivers
stuivers11406672stuivers
stutters83210472stutters
subers85722642su_bers
subitems1245492subitems
suckers133717622suckers
sudsers83310422sudsers
suers55128482su__ers
suffers133113542suffers
suite54829562suite__
suited74019422suite_d
suitor63311052suitor_
suits55028052suit__s
sulkers113613342sulkers
summers113616502summers
sumpters1238022sumpters
sunders84120052sunders
supers84622402su_pers
suppers113314702suppers
surfers103614132surfers
surgers83517482surgers
sutlers73116972sutlers
suttees74114062suttees
swifters14277482swifters
swithers144310532swithers
titers64526412_titers
tufters10298352tufters
uniters73814172uniters
utters63817122_utters
waiters104218622waiters
writers105513492writers

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.373479064.3
2DLD Change Limit1076711313.00035890.3
3Display Results1311310.0502620.0
 (SQL Overall)1786911313.42352203.0
 
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.