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 “interfusion” with Change Limit: [1] [2] [3] [4] [5]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

80 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
interfusion146498(None) 
interfusions1574391interfusions
interfusing1555832interfusing
interunion1046252inter_union
intrusion946812int_r_usion
infusion1146533in___fusion
intension948493inte__nsion
interaction13411813interaction
interbasin1246853interbasi_n
intercession14226443intercession
interdiffusion21132073interdiffusion
interferon1346853interf_eron
interfuse1247433interfus__e
interfused1445883interfus_ed
interfuses1347683interfus_es
intermission1464653intermission
interruption1466403interruption
intersession12175813intersession
intrusions1046333int_r_usions
inversion1247213inver__sion
perfusion14105883__perfusion
detrusion1044384det_r_usion
effusion1444614___effusion
extrusion1645254ext_r_usion
immersion1344284immer__sion
inclusion11166214in__clusion
incursion1145224incur__sion
indecision1344414inde_cision
infusions1246154in___fusions
ingression1145514in_gression
inhesion11116374inhe___sion
innervation1447444innervation
insertion9410594inser__tion
integration121310494integration
intensions1048404inte__nsions
intention9412014inte__ntion
interactions14410464interactions
interception1649394interception
intercessions15225884intercessions
intercessor1354334intercessor
interchain1546634interchai_n
interdiction1568144interdiction
interdiffusions22131884interdiffusions
interfacial1656294interfacial
interfacing1747704interfacing
interfaith1645924interf_aith
interfamily1953984interfamily
interfering1558924interfering
interferons1446744interf_erons
interfile12411044interf__ile
interfiling1546954interfiling
interfirm1446444interf__irm
interflow1544634interf__low
interfluvial1852674interfluvial
interior8513094inter___ior
interjection2198924interjection
interjoin1647894inter_joi_n
interleukin1554454interleuki_n
intermedin1347444intermedi_n
intermissions1594144intermissions
interneuron1154074interneuron
internucleon1451844internucleon
internuncio1352474internuncio_
internuncios1452704internuncios
interposing1447804interposing
interposition1586054interposition
interruptions1565734interruptions
interruptor13114054interruptor
intersection14610184intersection
intersessions13195284intersessions
interspersion1564394interspersion
interstation12410414interstation
interunit959834inter_uni_t
interurban1253634inter_urban
intervention1568384intervention
intrusive1245974int_r_usive
inversions1347004inver__sions
iteration9515034i_ter_ation
obtrusion1153724obt_r_usion
perfusions1595334__perfusions

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 Filter1786911488190.406440125.6
2DLD Change Limit148819808.71617074.2
3Display Results80800.0461739.1
 (SQL Overall)178691809.16819490.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.