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

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

58 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
interferential176397(None) 
inferential1457533in___ferential
deferential1554714__de_ferential
intelligential1572264intelligential
interdental1258414inter__dent_al
interference1756014interferen__ce
interferences1855474interferen_ces
interfertile1556424interfer__tile
interperceptual2171524interperceptual
interrenal1049814inter__ren__al
intersegmental1762374intersegment_al
preferential1753874_pre_ferential
referential1454684__re_ferential
circumferential24161745circumferential
conferential1755385__conferential
differential1963705__differential
incremental1556005in_cr_ement_al
indifferentism2371925indifferentism
indifferentist2172195indifferentist
inessential1154645in_e__ssential
inferentially1955485in___ferentially
influential1473905in___fluential
intercensal1356145inter__cen_sal
intercolonial1563975intercolon_ial
intercortical1764415intercor__tical
interdepending1982185interdepending
interfacial1656295interf___acial
interfamilial1862745interf_amilial
interfere12410815interfere_____
interfered1448535interfere____d
interferer1347735interfere____r
interferers1446185interfere___rs
interferes1349985interfere____s
interfering1558925interfer___ing
interferogram1972225interfer_ogram
interferon1346845interferon____
interferons1446745interferon___s
interfertility2063085interfertility
interfluvial1852675interf__luvial
interneuronal1362695interneuron__al
internuncial1453445inter__nuncial
interorbital1453625inter_orbit_al
interparochial21111675interparochial
interpermeating2063075interpermeating
interpersonal1564025interper_sonal
interpreting1588305inter_pre_ting
interpretive1775845inter_pre_tive
interracial1357075inter__r_acial
interstitial1255635inter__stitial
interterminal1554305interter_minal
intertextual1953725inter__textual
intertrial1049515inter_tr___ial
intervention1568385inter__vention
intervertebral1961655intervertebral
intracranial1463655int_racran_ial
reverential1484465__re_verential
torrential1054485__tor__rential
transferential1762565transferential

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 Filter178691950240.360496363.9
2DLD Change Limit95024588.89010688.9
3Display Results58580.0461260.9
 (SQL Overall)178691589.29619222.4
 
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.