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

88 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
invigilates155450(None) 
invigilate1444761invigilate_
invigilated1654001invigilated
invaginates1544842invaginates
invigilator1553602invigilator
invigilators1653182invigilators
invigorates15124242invigorates
annihilates1453153annihilates
initiates9411183in_iti_ates
intimidates14125743intimidates
invaginate1445053invaginate_
invaginated1654403invaginated
invalidates1554063invalidates
invigilating17113553invigilating
invigilation1655143invigilation
invigilations1764483invigilations
invigorate14134373invigorate_
invigorated16133733invigorated
inviolate1246393invi_olate_
vigilantes1443133__vigilantes
angulates10310864an__gulates
annihilate1353474annihilate_
annihilated1552874annihilated
anticipates1586984anticipates
assimilates1354414assimilates
dissimilates15125194dissimilates
evaginates1475994_evaginates
immigrates1544024immig_rates
inactivates1645044inactivates
inaugurates1253484inaugurates
incinerates1346034incinerates
incivilities1756334incivilities
incriminates1654324incriminates
indagates1146574indag__ates
indicates12312584in__dicates
individuates1752794individuates
inebriates1246064inebri_ates
infiltrates1463944infiltrates
infinites1258694infini__tes
inflates11512194in___flates
infuriates1346864infuri_ates
ingates82716914in__g__ates
ingrates9514174in__g_rates
ingurgitates1452064ingurgitates
initiate8412694in_iti_ate_
initiated10510114in_iti_ated
inoculates1248704in_oculates
inosculates1345144inosculates
inseminates1345894inseminates
insinuates1045464insi_nuates
insolates9311274in__solates
instigates1148424in_stigates
insufflates17132404insufflates
insulates9311844in__sulates
integrates111010784integ_rates
intimates111013314in__timates
intimidate13146054intimidate_
intimidated15124924intimidated
intoxicates2054444intoxicates
invalidate1444424invalidate_
invalidated1653614invalidated
inveigles1343024inveig_l__es
investigates16104214investigates
inviabilities1848824inviabilities
invigorator1553384invigorator
invigorators1653144invigorators
inviolacies1652794invi_olacies
inviolately1752764invi_olately
invirile1145814inviril__e_
invisibles1543454invisi_bles
invites103915814inv__i__tes
invocates1447644inv__ocates
involutes1245104inv__olutes
irrigates1057254irrig__ates
levigates1346494levig__ates
navigates1345874navig__ates
noviciates1543764novici_ates
novitiates1343734noviti_ates
originates1145964_originates
reinvigorates17122264reinvigorates
reviolates1347534revi_olates
sibilates1148444__sibilates
ungulates1048354un__gulates
vigilances1643534__vigilances
vigilante1343634__vigilante_
violates11311194__vi_olates
vitiates112311434__viti_ates
vizirates2144664__vizirates

Search took 9 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.1531167915.0
2DLD Change Limit148819888.25318032.1
3Display Results88880.0461913.0
 (SQL Overall)178691888.45221141.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.