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

54 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
invigorator155338(None) 
invigorators1653141invigorators
invigilator1553602invigilator
invigorate14134372invigorat_e
invigorated16133732invigorated
invigorates15124242invigorates
invigoration1654592invigoration
reinvigorator1771872reinvigorator
inaugurator1252423inaugurator
incinerator1363763incinerator
infiltrator1453023infiltrator
integrator1157123integ_rator
invigilators1653183invigilators
invigorating1752983invigorating
invigorations1753913invigorations
reinvigorators1891653reinvigorators
avigator12236774_avig__ator
denigrator1245224denig_rator
evaporator1553644_evaporator
inamorato1153304in_amorato_
inamoratos1253214in_amoratos
inaugurators1352074inaugurators
incinerators1463434incinerators
incorporator1653394incorporator
indagator1144314indag__ator
indicator1249014indi__cator
infiltrators1552744infiltrators
initiator998114in_i_tiator
innovator1244414in__novator
insinuator1054234insi_nuator
inspirator1245774in_spirator
instigator1146414instig__ator
integrators1246524integ_rators
intimidator1454534intimidator
invalidator1553194invalidator
invertor11238974inv__er_tor
invigilate1444764invigilat_e
invigilated1654004invigilated
invigilates1554504invigilates
invigilation1655144invigilation
inviolate1246394invi_olat_e
invitatory1644784invi__tatory
invocatory1844164inv__ocatory
irrigator1045704irrig__ator
meliorator12105224meli_orator
migrator1147874__mig_rator
navigator1364884navig__ator
nitrator849554_n_i_trator
reinvigorate16132304reinvigorat_e
reinvigorated18102174reinvigorated
reinvigorates17122264reinvigorates
reinvigoration18152714reinvigoration
vibrator13227344__vi_brator
violator1146284__vi_olator

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.423422437.4
2DLD Change Limit148819549.29616008.9
3Display Results54540.0331636.4
 (SQL Overall)178691549.75218323.5
 
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.