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

65 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
interleaf124804(None) 
interlap1048592interl_ap
interlay11310042interl_ay
interleave1347612interleave
interlend10310112interlend
interlent9416732interlent
interloan948772interloan
interplead1345602interplead
waterleaf1543702waterleaf
intellect1147443intellect
interbed112413103interbe_d
interbeds12238903interbeds
intercede121210983intercede
intercell1148173intercell
intercept13410973intercept
interclan1148603interclan
interest8319183inter_est
interfere12410813interfere
intergraft1446173intergraft
interject1849603interject
interlace11311913interlace
interlaid1049353interlaid
interlaps1148233interlaps
interlard1048453interlard
interlays1248083interlays
interleaved1545863interleaved
interleaves1447053interleaves
interlends1148603interlends
interline91218013interline
interlinear11145693interlinear
interlink131310663interlink
interloans1048263interloans
interlocal1247093interlocal
interlock1546233interlock
interloop1145833interloop
interlope1149183interlope
interlude1047293interlude
interlunar1045433interlunar
intermat101114613inter_mat
interment11419223interment
intermesh1446703intermesh
internal8414093inter_nal
interne73218153interne__
interned93016653interne_d
internee82718523interne_e
internees93014843internees
internes82721233interne_s
interocean1246483interocean
interplay1447163interplay
interpleads1444523interpleads
interpled1239603interple_d
interred92615263interre_d
interrenal1049823interrenal
interrex15249823interre_x
intersect11412113intersect
intersex15209733interse_x
interterm1148813interterm
interval11710473inter_val
intervene12912253intervene
interwar1148263inter_war
interweave1646253interweave
intreat7416303int_r_eat
liverleaf1542103liverleaf
overleaf14237973_overleaf
waterleafs1642703waterleafs

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.596299817.1
2DLD Change Limit148641657.34320242.5
3Display Results65650.0302166.7
 (SQL Overall)178691657.96922423.3
 
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.