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

113 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
titlists83729(None) 
titlist7312921titlist_
biblists1236872biblists
dialists9411412dialists
midlists1137522midlists
shitlists1245532shitlists
titbits935802titbi_ts
totalists9310752totalists
violists1137662violists
vitalists1239222vitalists
waitlists1244602waitlists
airlifts1143633airlifts
altoists848753altoists
artists74215593art_ists
atticists1167943atticists
autists73814853aut_ists
biblist11310833biblist_
cellists1038563cellists
cultists10107633cultists
cyclists1545713cyclists
delists84414173_delists
dialist8517763dialist_
diallists1056003diallists
diarists9410363diarists
ditheists1345573ditheists
dualists958243dualists
duelists966003duelists
elitists848543elit_ists
enlists749393_enlists
entwists1156143entwists
fatalists12310023fatalists
fideists1245543fideists
finalists123010163finalists
hitless103211193hitles_s
holists104413963_holists
idylists1244123idylists
insists739083_insists
intwists1145593intwists
kitlings13318103kitlings
libelists1146953libelists
lists56628693___lists
lutists73810273lut_ists
metalists11412663metalists
metrists1039853metrists
midlist10312513midlist_
mitises9315543mit_ises
niellists944793niellists
nihilists1244853nihilists
nitwits1035053nitwi_ts
oculists1037133oculists
oralists8611803oralists
otitises839163otit_ises
outlasts8108713outlasts
pianists1049013pianists
pietists1038323pietists
pollists10910823pollists
realists83014843realists
relists73817053_relists
retwists1135603retwists
ritualists1046173ritualists
sciolists1147213sciolists
shitlist1148723shitlist_
simplists13266503simplists
sitarists949373sitarists
statists8310163stat_ists
stylists11207023stylists
tachists1348183tachists
tallises82713263tallises
tallits73215993talli_ts
tanists7313663t_anists
tennists8297793tennists
theists1039153t_heists
tidbits1035183tidbi_ts
tieless72512563tieles_s
tilings84212793ti_lings
tillite7313563tilli_te
tillites8312833tillites
tilts55325613ti_l__ts
tintless8239863tintles_s
tipless92610063tiples_s
titanisms1147423titanisms
titbit839823titbi_t_
tithings12327693tithings
titians72710453tit_ians
titis56023813tit_i__s
titlarks1243693titlarks
titles63719923titl__es
titling83715793titli_ng
titrants838483titrants
titties73617363titti_es
totalises9311783totalises
totalisms1139813totalisms
totalist8315583totalist_
totemists1146373totemists
tourists838313tourists
tribalists1286943tribalists
tritheists1344623tritheists
tsarists857303tsarists
tubaists1055103tubaists
tubists9288323t_ubists
twists9549753__twists
typists1236173t_ypists
tzarists1755693tzarists
untwists1144623untwists
utilises848973uti_lises
vibists1256483vi_bists
violist10312143violist_
vitalises12310093vitalises
vitalisms1448513vitalisms
vitalist11313393vitalist_
waitlist1147743waitlist_
witless103310983witles_s
witlings12328443witlings

Search took 7 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.420425454.8
2DLD Change Limit1461621136.39022873.6
3Display Results1131130.0462456.5
 (SQL Overall)1786911136.85626063.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.