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

47 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
intagli84502(None) 
intaglio943021intaglio
intaglios1042662intaglios
antalgic1146703antalgic
entail61114343entail_
entails7912823entails
entangle966253entangle
finagle11238313fin_agle
incage93513623incag_e
incaged114010443incaged
incages103013883incages
infall939403infa_ll
infalls1038943infalls
ingle64120433in__gle
inhale9411513inha_le
inhaul936803inhaul_
inhauls1035523inhauls
innage73011573innag_e
innages82911303innages
instable10313203instable
instal6712193insta_l_
install779363insta_ll
installs858923installs
instals7611713insta_ls
intact8314663inta_ct
intactly1344743intactly
intaglioed1251573intaglioed
intake10510863inta_ke
intakes11310943intakes
intarsia845763intarsia
integer837993integer
inti46626083int___i
intitle7610583intitle
invalid1146393inva_lid
inwall938343inwa_ll
inwalls1037283inwalls
italic839903i_ta_lic
mintage101110123mintag_e
mintages111110513mintages
onagri754963on_agri
pintail9311183pintail_
pintails10310163pintails
tali46837163__ta_li
untangle966323untangle
vintage11128143vintag_e
vintager12104823vintager
vintages12118273vintages

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 Filter1786911340270.423422437.4
2DLD Change Limit134027476.59320328.7
3Display Results47470.0162937.5
 (SQL Overall)178691477.03225411.1
 
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.