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

51 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
catarrh124500(None) 
catarrhs1344331catarrhs
catarrhal1452492catarrhal
aargh96314083_a_argh
aarrgh10786303_a_arrgh
anarch11310393_anarch
autarch1246623autarch
cabaret112519043cabaret
calash11312433cala_sh
camorra11115763camorra
canard9314763cana_rd
canards10311203canards
canary11314693cana_ry
carr65434703c__arr_
carrs75730853c__arrs
carry105823783c__arry
catalo8314853cata_lo
catalog1038003catalog
catalos9414163catalos
catalpa1136503catalpa
cataract1249413cataract
catarrhine1552503catarrhine
catawba1443703catawba
catbird1235243catbird
catch125120373cat__ch
cater74840723cat_er_
cateran9313773cateran
catered103117773catered
caterer92815943caterer
caterers102814403caterers
caters85336503cat_ers
catfish1559023catfish
cattery123811603cattery
cattish12410723cattish
cavalry1554963cavalry
charr104821783c_harr_
charro114212953c_harro
charrs115219193c_harrs
charry145012113c_harry
datary10310243data_ry
haftarah17124183haftarah
satara6315533sata_ra
sataras7315063sataras
starch113013203_starch
starry94911673_starry
tarre55825633__tarre
tarry85422513__tarry
tatar56122063tata_r_
tatars64619793tata_rs
zamarra1843783zamarra
zamarro1842883zamarro

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 Filter1786911340270.1531167915.0
2DLD Change Limit134027517.05019010.9
3Display Results51510.0133923.1
 (SQL Overall)178691517.21624763.2
 
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.