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

70 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
obturates115700(None) 
obturate1077771obturate_
obturated1245951obturated
maturates11311762maturates
obdurate1175122obdurate_
objurgates2052232objurgates
obturator1144702obturator
obturators1244302obturators
outrates82421372out_rates
saturates9811602saturates
actuates10310313actu_ates
berates94126873_b_erates
borates94823013_b_orates
butyrates1446083butyrates
citrates102315093cit_rates
curates95323833__curates
depurates1239823depurates
doctorates1346203doctorates
extubates1844843extubates
fortunates1345263fortunates
indurates10310693indurates
intubates1147123intubates
iterates81317823_iterates
literates91415653literates
maturate10312613maturate_
maturated1249163maturated
micturates1456093micturates
nitrates82516223nit_rates
obduracies1552383obduracies
obdurately1652053obdurately
obfuscates17102043obfuscates
obituaries1243343obituaries
objurgate1942183objurgate_
objurgated2151923objurgated
oblates91913243ob__lates
obligates12207853obligates
obliterates1345123obliterates
obsecrates1444583obsecrates
obtrudes1144073obt_rudes
obturating1346573obturating
obturation1297143obturation
obturations13116423obturations
obtusities1253823obtusities
obviates1345153ob_viates
operates10515413o_perates
orates64328613o___rates
osculates11109393osculates
ostomates1149343ostomates
outbraves1436713outbraves
outdates93114743out_dates
outraces102217863out_races
outrages92215933out_rages
outrate72323183out_rate_
outrated92219313out_rated
outraves112313833out_raves
outskates13177153outskates
outstates91710753outstates
outtrades1077693outtrades
outwrites1238233outwrites
overrates12414623overrates
ovulates1148523o_vulates
postulates1268963postulates
saturate8312813saturate_
saturated1038993saturated
saturater947903saturater
saturaters1045563saturaters
situates8310373situ_ates
titrates82314663tit_rates
triturates1046763triturates
urates65027763___urates

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 Filter1786911486410.420425454.8
2DLD Change Limit148641706.92321470.6
3Display Results70700.0302333.3
 (SQL Overall)178691707.37324235.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.