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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

108 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
introits85971(None) 
introit7414531introit_
intromits1166211intromits
intermits111212202intermits
intorts7310972int_orts
intrants8312862intrants
intreats8311542intreats
introfies1247232introfies
intromit1048742intromit_
introns73515022intro_ns
intros64215772intro__s
intrusts837722intrusts
intuits7310312int_uits
androids1047753androids
aneroids9310203aneroids
attrits7310613attr_its
centroids1247043centroids
droits74314313__droits
enroots738713en_roots
entoils7810733ent_oils
entrails8310163entrails
entrains8312963entrains
entrants8311753entrants
entreats839773entreats
entries71523163entr_ies
entropies11411023entropies
entrusts847113entrusts
incipits1246263incipits
incross937663incro_ss
incrusts1036253incrusts
indrafts1295583indrafts
indris7311963indr_i_s
inertias8410383inertias
inerts64517023iner__ts
infracts1346623infracts
ingots7912063in_go_ts
ingrafts12105803ingrafts
ingrains948983ingrains
ingroups1143483ingroups
ingrowth1553023ingrowth
ingrowths1641923ingrowths
inhabits1355473inhabits
inherits11310103inherits
inhibits1345203inhibits
inkpots1335173inkpo_ts
inroads837043in_roads
instrokes1345353instrokes
instructs1145793instructs
intarsias945923intarsias
intents72115703int_ents
interacts11312123interacts
intercity14410003intercity
intercuts1148783intercuts
interdicts1347083interdicts
interests9312553interests
interims101013073interims
interiors9513563interiors
interjoins1747953interjoins
interknits1456203interknits
intermats111412453intermats
intermit101213593intermit_
internist9414883internist
internists10410243internists
interties9320333interties
inthrones1299673inthrones
intimist10410213intimist
intimists1147493intimists
intis55121643int__i_s
intombs1144153int_ombs
intones7816543int_ones
intort6418923int_ort_
intracity1448423intracity
intrados946563intrados
intranets949263intranets
intrant7318753intrant_
intreat7416303intreat_
intro54915853intro___
introfied1345603introfied
introfy1344753intro_fy
introjects1953703introjects
intron64215023intro__n
introrse846043introrse
introverts1344583introverts
intrudes937493intrudes
intrust7311493intrust_
intuit6314083int_uit_
intwist1038043int_wist
intwists1145593intwists
nitrids8269633nitr_ids
nitrils72810703nitr_ils
nitrite72314463nitr_ite
nitrites82313453nitr_ites
nitros64214123nitro__s
nitrous73512483nitro_us
nitwits1035053nit_wits
octrois938333octroi_s
outroots839873outroots
patriots1038053patriots
pinkroots1543353pinkroots
retrofits1245353retrofits
straits74916323_straits
toits55327473__t_oits
traits65121983__traits
trois57226093__troi_s
trots56629943__tro_ts
trouts66116633__trouts
unroots738563un_roots
untrims938613untr_ims

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621086.95321021.4
3Display Results1081080.0462347.8
 (SQL Overall)1786911087.42224075.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.