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

57 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
interunit95983(None) 
interknit1358331interknit
interknits1456202interknits
interknot1356902interknot
intermit101213592inter_mit
internist9414882inter_nist
interunion1046252interunion
inherent11412793inheren_t
inherit10312973inher__it
integrant1049833integran_t
intent63122773inte__n_t
interact10316463inter_act
intercept13410963intercept
intercity14410003inter_city
intercut10411113inter_cut
interdict12410213interdict
interest8319183inter_est
interfaith1645923interfaith
interim9912873inter__im
interionic1248253interionic
interject1849603interject
interjoin1647893interjoin
interknots1455023interknots
interlaid1049353interlaid
interlent9416733interlent
interline91218003interline
interlink131310663interlink
interlunar1045433interlunar
intermat101114613inter_mat
interment11419223interment
intermits111212203inter_mits
intermix17156873inter_mix
intermont11513573intermont
intern64016543inter_n__
internal8414083inter_nal
interne73218143inter_n_e
interned93016653inter_ned
internee82718513inter_nee
internes82721233inter_nes
interning10315253inter_ning
internists10410243inter_nists
interns73116773inter_n_s
internuncio1352473internuncio
interpoint12411883interpoint
interpret11413363interpret
interring10315423interring
interrupt1147243interrupt
intersect11412113intersect
intertie8317613inter_tie
intertwist1356303intertwist
intranet8418443int_ranet
intrant7318753int_ran_t
introit7414533int_r_oit
intromit1048743int_romit
intrust7311493int_ru_st
intuit6314083int__u_it
iterant7317783i_teran_t

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.1731032896.0
2DLD Change Limit148641577.01621186.0
3Display Results57570.0301900.0
 (SQL Overall)178691577.21924752.9
 
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.