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

105 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
quittors1715541(None) 
quitters17238521quitters
quittor16285601quittor_
questors17147012questors
quieters17248732quieters
quilters17228432quilters
quintars17337562quintars
quitter162910752quitter_
suitors73012492sui_tors
abettors1056133abettors
acquitters2142953acquitters
agitators1046623agitators
auditors947613auditors
authors10311853au_thors
aviators11169903aviators
bettors93312473_bettors
bitters94920363_bitters
butters94521723bu_tters
buttons9310333bu_ttons
chitters133711173chitters
citators10310253_citators
critters103511323critters
critturs10374593critturs
cuittles1045903cuittles
curators10311723curators
cutters94218963cu_tters
dittos74111973_ditto_s
editors839423edi_tors
emitters10349643emitters
equators1737473equ_ators
evictors13276853evictors
fitters104517753_fitters
flitters114312173flitters
fritters113810783fritters
functors1335743functors
glitters93710543glitters
gritters94210633gritters
guitars8116863gui_tars
gutters83715513gu_tters
hitters104717593_hitters
imitators1147013imitators
jitters144314473_jitters
knitters12336623knitters
lictors93212593_lictors
litters73422573_litters
mutters94117143mu_tters
muttons949283mu_ttons
nutters74215433nu_tters
omitters10277653omitters
putters94219193pu_tters
qintars16268573q_intars
quaestors1843613quaestors
quarters173110453quarters
quartos16328733quarto_s
questers17168763questers
questor16146633questor_
quietens17246343quietens
quieter162810333quieter_
quiets154014373quiet__s
quietus16286393quiet_us
quilter16279803quilter_
quilts154112543quilt__s
quinoas16337873qui_noas
quinols16297243qui_nols
quintals17288003quintals
quintans17337873quintans
quintar16478603quintar_
quintas163611713quint_as
quintes164114713quint_es
quintets17347203quintets
quintics19266983quintics
quintins17329863quintins
quints154316563quint__s
quippers2184813quippers
quipsters2043593quipsters
quirts154213553quirt__s
quitches2236193quitches
quits144122353qui_t__s
quitted17339893quitt_ed
quitting18228833quitting
quivers19298753qui_vers
quixotes2443553quixotes
quixotry2741403quixotry
quizzers2542943quizzers
quoters16369263qu_oters
remittors11256283remittors
ritters74020623_ritters
sitters74221553_sitters
skitters12349553skitters
slitters84014133slitters
spitters104113383spitters
squatters1834943squatters
squinters1835513squinters
squirters1835063squirters
suiters73618883sui_ters
suitor63311053sui_tor_
titters74219623_titters
tuitions838283tuitions
tutors6912333tu__tors
twitters11296773twitters
utters63817123_u_tters
viators102712023_viators
victors123311183_victors
whitters14359403whitters
wittols1035733_wittols

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 Limit1461621057.51619446.8
3Display Results1051050.0462282.6
 (SQL Overall)1786911057.71823152.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.