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

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
introfy134475(None) 
entropy1247352entropy
intro54915852intro__
introit7414532introit
intron64215022intro_n
introns73515022introns
intros64215772intro_s
nitrify1335792nitrify
entry82414263entr__y
gentrify1544683gentrify
incony1139083in_cony
incross937663incross
indraft1199563indraft
inertly1038543inertly
infeoff1253263infeoff
ingraft1199493ingraft
ingroup1044333ingroup
ingrown1145393ingrown
inro45920793in_ro__
inroad737933in_road
instroke1245583instroke
interlay11310043interlay
inthrone1179473inthrone
into45026153int_o__
intomb1036403int_omb
intone61115433int_one
intort6418923int_ort
intorts7310973intorts
intown936153int_own
intraday1244803intraday
intrant7318753intrant
intreat7416303intreat
introfied1345603introfied
introfies1247233introfies
introfying1744853introfying
introits859713introits
intromit1048743intromit
introrse846043introrse
intrude837403intrude
intrust7311493intrust
irony85015903i__rony
isotropy1344233isotropy
metrify1535623metrify
nigrify1444133nigrify
nitro54914353nitro__
nitros64214123nitro_s
nitroso7326453nitroso
nitrosyl1142613nitrosyl
nitrous73512483nitrous
petrify1536573petrify
putrefy1543313putrefy
stroy87720393_stro_y
troy77429683__tro_y
untrod769853untro_d
untruly1046293untruly
vitrify1645003vitrify
wintrily1445373wintrily
wintry12498923wintr__y

Search took 7 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.390458182.1
2DLD Change Limit134027586.06022116.7
3Display Results58580.0331757.6
 (SQL Overall)178691586.48327563.0
 
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.