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

56 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
calibrates144695(None) 
calibrate1347741calibrate_
calibrated1545641calibrated
calibrator1444212calibrator
calibrators1553962calibrators
calibres1237102calibr__es
califates14310112cali_fates
caliphates1745132caliphates
celebrates1447672celebrates
celibates1358632celib_ates
librates103412952__librates
recalibrates1663462recalibrates
acierates11310813_acierates
alienates9310683_alienates
aliterates101510753_aliterates
amirates101114793_ami_rates
cabinmates1643893cabinmates
calcarate1347703calcarate_
calculates1498703calculates
calibrating1645343calibrating
calibration1545993calibration
calibrations1645153calibrations
calibre1136603calibr__e_
calibred1335053calibr__ed
califate13310483cali_fate_
caliphate1645293caliphate_
canebrakes1843553canebrakes
carates95630613ca___rates
castrates11312673ca_strates
cavitates14168963cavi_tates
celebrate1348083celebrate_
celebrated1556223celebrated
celibate1259313celib_ate_
cerebrates1447913cerebrates
chalybeates2151903chalybeates
chlorates142512273chl_orates
ciliates10413453cili__ates
citrates102315093c__itrates
clathrates1545273clathrates
climates12311973c_li_mates
clofibrates1851753clofibrates
deliberates1446793deliberates
kalifates1646133kali_fates
kaliphates1943033kaliphates
liberates111012943__liberates
librate93214233__librate_
librated113110313__librated
meliorates1288903meliorates
recalibrate1553673recalibrate_
recalibrated1753183recalibrated
revibrates1546273revibrates
salivates1239293sali_vates
uncalibrated1752933uncalibrated
valerates12310543val_erates
validates1338243vali_dates
vibrates132210613__vibrates

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 Filter1786911406030.406440125.6
2DLD Change Limit140603565.78324313.2
3Display Results56560.0301866.7
 (SQL Overall)178691566.21928733.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.