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

56 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
lutenists95659(None) 
lutanists966841lutanists
lutenist8610661lutenist_
eugenists1046172eugenists
euthenists1345892euthenists
luminists1147172luminists
lutanist8410272lutanist_
lutefisks1641732lutefisks
lutists73810272lut__ists
alienists946913alienists
autecisms1346033autecisms
auteurists1045093auteurists
autists73814853aut__ists
botanists1148203botanists
cuteness1039673cutenes_s
cutinises1148513cutinises
detentists1145503detentists
duelists966003du_elists
duettists1043043duettists
ecumenists14144203ecumenists
eugenist949623eugenist_
euthenist1249033euthenist_
flutists11256413flut__ists
futurists1245583futurists
glutenins1044223gluteni_ns
humanists1446843humanists
internists10410243internists
larcenists1244353larcenists
lateness82614073latenes_s
latents75214313laten__ts
latests73910313late__sts
legists899593l__egists
libelists1146953libelists
liteness82213213litenes_s
luminisms1346543luminisms
luminist10410563luminist_
luteciums1343123luteciums
lutefisk1542693lutefis_k
luteinizes1943883luteinizes
luteins7310103lute_i_ns
lutetiums1142923lutetiums
lutfisks1542333lut_fisks
lutist64317553lut__ist_
muteness1039013mutenes_s
plenists1038253_plenists
plutonisms1485043plutonisms
querists1736543qu_erists
quietists1864463quietists
routinists1046093routinists
satanists948233satanists
tanists7313653__tanists
tennists8297793__tennists
totemists1146373totemists
ultraists947333ultraists
utensils8124963_utensils
utopists1045773_utopists

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.436409841.7
2DLD Change Limit148641566.62322443.2
3Display Results56560.0163500.0
 (SQL Overall)178691567.07525256.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.