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

45 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
sciolists114721(None) 
sciolisms1346221sciolisms
sciolist10410231sciolist_
scholiasts1544092scholiasts
sciolism1247092sciolis_m
sciolistic1446592sciolistic
shitlists1245532shitlists
socialists1248492socialists
violists1137662_violists
biblists1236873_biblists
cellists1038563_cellists
cyclists1545713_cyclists
dialists9411413_dialists
holists104413963__holists
midlists1137523_midlists
oculists1037133oc_ulists
racialists1247703racialists
sarodists1056593sarodists
schists1248543sc__hists
scholiast1446303scholiast_
scholiums1644843scholiums
scientists1244963scientists
scolices1238733sc_olices
scolioses1155613sc_olioses
scoliosis1144743sc_oliosis
serialists10810363serialists
shitlist1148723shitlist_
simonists1146763simonists
simplists13266503simplists
socialises1258253socialises
socialisms1447643socialisms
socialist11411393socialist_
sociolects1452413sociolects
sociologists1547943sociologists
sodalists1038153sodalists
sodomists1255923sodomists
soloists869153s__oloists
specialists1546203specialists
stylists11207023s_tylists
sumoists1046733sumo_ists
symbolists1764373symbolists
titlists837293_titlists
unionists946213unionists
violist10312143_violist_
waitlists1244603waitlists

Search took 9 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.423422437.4
2DLD Change Limit148641457.70319296.5
3Display Results45450.0162812.5
 (SQL Overall)178691458.14221946.8
 
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.