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

43 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
refrigerates165350(None) 
refrigerate1553621refrigerate_
refrigerated1753201refrigerated
refrigerants1651632refrigerants
refrigerator1661952refrigerator
refrigerators1761752refrigerators
refrigerant1552393refrigera_nt
refrigerating1853183refrigerating
refrigeration1764153refrigeration
refrigerations1863773refrigerations
reiterates10412003re__iterates
remigrates1348583re_mig_rates
unrefrigerated196923unrefrigerated
deflagrates16133244deflag_rates
deliberates1446794de_liberates
denigrates1298114de_nig_rates
desiderates1345814de_siderates
emigrates1248584_e_mig_rates
exaggerates2054134_exaggerates
frigates12310934__frig__ates
preliterates1455344pre_literates
recreates11313364recr__e_ates
recriminates1654884recriminates
recuperates1545604re_cuperates
refigures1344544ref_igur__es
refineries1347064ref_iner_ies
regelates10311114re___gelates
regenerates1247474re_generates
regrates92618404re___g_rates
reintegrates1374944reintegrates
reinvigorates17122264reinvigorates
reiterate9412934re__iterate_
reiterated11410154re__iterated
remigrate1249224re_mig_rate_
remigrated1447494re_mig_rated
remunerates1375944re_munerates
reoperates1249664re__operates
reorientates1253104reorientates
reregulates12135804re_regulates
retrogrades1354004retrog_rades
revegetates1553934re_vegetates
reverberates1753514reverberates
revibrates1546274re_vi_brates

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 Filter1786911247900.390458182.1
2DLD Change Limit124790437.37616918.4
3Display Results43430.0162687.5
 (SQL Overall)178691437.78222962.1
 
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.