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

86 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
stannite84758(None) 
stannites947021stannites
mannite9312902_mannite
stagnate947242stagnate
stanine73417072sta_nine
stannic936662stanni_c
sternite8310542sternite
stibnite1044072stibnite
tannate71813522_tannate
braunite1047253braunite
cannie83819363_canni_e
cyanite122710763cya_nite
dunnite857333_dunnite
gahnite1135973_gahnite
granite82017083gra_nite
grannie8310353granni_e
kainite1149543_kainite
kyanite14237313kya_nite
mannites10312613_mannites
nannie63713223_nanni_e
samite83020603s_a_mite
sanity9316203s_a_nity
saponite10410533saponite
scanning113310773scanning
selenite81713113selenite
sennit63117923s_ennit_
sennits73811283s_ennits
shannies113411263shannies
sienite7312713s_ienite
slainte738543slain_te
smaltite1046903smaltite
spanning113311083spanning
stabile9312063sta_bile
stacte82113913sta__cte
staggie9138463staggi_e
stagnated1145143stagnated
stagnates1046733stagnates
staining9413373staining
staithe1037723sta__ithe
staminate1187983staminate
stance84316913sta_n_ce
standee83514513sta_ndee
standing103413633standing
standish1238543standish
standpipe1443343standpipe
stane55933003sta_n__e
stanging104013653stanging
stanhope1344273stanhope
stanines85115673stanines
staning83922243sta_ning
stannary1144613stannary
stannous846443stannous
stannum944643stann_um
stannums1043803stannums
starlike1238813starlike
starlit71512913starlit_
starnose8136693starnose
state56237333sta___te
statice92614033sta_tice
stative102612933sta_tive
statute7419323sta_tute
steatite8310583steatite
stellite839533stellite
sternites9310073sternites
stibnites1144043stibnites
stilbite1045423stilbite
stunning9298463stunning
stylite10219613st_ylite
swanlike1535313swanlike
swanning12338813swanning
syenite1039773s_yenite
taconite1049313_taconite
taeniae739083_taeniae
tannage8209583_tannage
tannates81911953_tannates
tannic82811483_tanni_c
tannin62613933_tanni_n
tanning83618253_tanning
tannins72813223_tannins
tannish101610573_tannish
tanzanite1844533_tanzanite
taxite13511303_ta_xite
titanite898433tita_nite
umangite1144823umangite
uraninite946743uraninite
uranite72515693ura_nite

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 Filter1786911461620.440406115.9
2DLD Change Limit146162867.95318378.2
3Display Results86860.0302866.7
 (SQL Overall)178691868.42321214.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.