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

60 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
stilbite104542(None) 
stilbites1144831stilbites
stellite839542stellite
stibine938662sti_bine
stibnite1044072stibnite
stilbene1043612stilbene
stylite10219612styl_ite
tillite7313562_tillite
albite8313313__albite
astilbe945653astilb__e
illite63414923__illite
nailbiter1142673nailbiter
niobite937953_niobite
satellite947063satellite
shilpit1247103shilpit_
sienite7312713s_ienite
silkie103313403s_ilki_e
smaltite1046903smaltite
stabile9312063st_abile
stannite847583stannite
steatite8310583steatite
stellate8310503stellate
stellites938133stellites
sternite8310543sternite
stibial946583sti_bial
stibines1038153sti_bines
stibium1145843sti_bium
stibnites1144043stibnites
stickit1339463stickit_
stiffie13245773stiffi_e
stilbenes1143933stilbenes
stile54931573stil___e
stiletto843793stiletto
stillbirth1561183stillbirth
stillier868833stillier
stilling93415323stilling
stilt54831983stil__t_
stilted83511473stil__ted
stilting93312403stilting
stilts67915313stil__ts
stipites1039653sti_pites
strobile1047033strobile
stylate10179773styl_ate
stylise10208953styl_ise
stylites11168693styl_ites
stylize19177453styl_ize
stylobate1442763stylobate
stylolite1244383stylolite
sulfite10310473s_ulfite
sylvite13266353s_ylvite
tibiae838483_ti_biae
tidbit938493_tidbit_
tidbits1035183_tidbits
tillites8312833_tillites
titbit839823_titbit_
titbits935803_titbits
trilobite1144813trilobite
utilise749063util_ise
utility1038713util_ity
utilize1648813util_ize

Search took 10 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 Limit146162609.44015483.3
3Display Results60600.0302000.0
 (SQL Overall)178691609.89018067.8
 
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.