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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

93 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
arbalists114848(None) 
arbalests1144121arbalests
arbalist10313331arbalist_
aerialists1089522aerialists
annalists949062annalists
arbalest1039522arbalest_
arbelests1143652arbelests
arborists1147452arborists
cabalists1339152cabalists
cabbalists1644722cabbalists
herbalists1546192herbalists
kabalists1546292kabalists
kabbalists1843212kabbalists
oralists8611802or_alists
realists83014842_realists
tribalists1286942tribalists
urbanists11105482urbanists
verbalists1546152verbalists
abatises10311013a_batises
ableists1036543a_bleists
aerialist9914263aerialist_
alkalises13167483alkalises
analysts11167443a_nalysts
animalists1258243animalists
annalist8413753annalist_
apiarists1147883apiarists
aquarists1856123aquarists
arbelest1049503arbelest_
arborist10411613arborist_
archaists1446583archaists
argalis84214193argali__s
arsonists947413arsonists
artists74215593ar__tists
atavists1137583a_tavists
atonalists1048493atonalists
aviarists1246613aviarists
barbarisms1644943barbarisms
biblists1236873bib_lists
bubalises1346323bubalises
cabalisms1548433cabalisms
cabalist12314503cabalist_
cabbalisms1844523cabbalisms
cabbalist1547643cabbalist_
cembalists1645243cembalists
cymbalists1944073cymbalists
dialists9411413_dialists
dualists958243_dualists
fabulists1444723fabulists
fatalists12310023fatalists
finalists123010163finalists
formalists15217623formalists
globalists1344693globalists
herbalisms1746283herbalisms
herbalist1449813herbalist_
idealists1047223idealists
kabalisms1745953kabalisms
kabalist14410083kabalist_
kabbalisms2042983kabbalisms
kabbalist1744613kabbalist_
legalists1047943legalists
libelists1146953libelists
localists11149793localists
loyalists12137473loyalists
medalists1249373medalists
metalists11412663metalists
moralists11311103moralists
muralists1148163muralists
oralisms10610973or_alisms
oralist7619633or_alist_
organists1047383organists
parablasts1444133parablasts
racialists1247703racialists
racists92613323_r_acists
rapists92510753_r_apists
realises82420183_realises
realisms102212163_realisms
realist73225383_realist_
relists73817053_r_elists
royalists12178113royalists
ruralists947643ruralists
serialists10810363serialists
sodalists1038153sodalists
totalists9310753totalists
tribalisms1446513tribalisms
tribalist1149953tribalist_
tubaists1055103tuba_ists
urbanises11106643urbanises
urbanisms13115993urbanisms
urbanist10109073urbanist_
verbalisms1746113verbalisms
verbalist1449503verbalist_
vitalists1239223vitalists
vocalists14108893vocalists

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 Filter1786911486410.420425454.8
2DLD Change Limit148641936.89021573.4
3Display Results93930.0501860.0
 (SQL Overall)178691937.36024278.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.