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 “catbrier” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

118 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
catbrier123617(None) 
catbriers1344141catbriers
carrier93619582ca_rrier
catchier15329862catchier
caterer92815942cater_er
cattier93317072cat_tier
waterier11312082waterier
aerier64823153_a_erier
airier64619363_a_irier
ambries111614553_ambries
angrier839023_angrier
atelier7311623_atelier
babier103515573ba_b_ier
barrier94017733ba_rrier
battier93515713bat_tier
brier74527403___brier
cabbie122913353ca_bbie_
cabbies133115163ca_bbies
cabdriver1741673cabdriver
caber95126833ca_b__er
cabler104519173ca_b_ler
cagier93715933ca__gier
cahier113615773ca__hier
cakier123115243ca__kier
calorie92716893calorie_
calories102919553calories
camber124418483camb__er
cambric1537383cambri_c
cambrics1645253cambrics
campier133313273ca_mpier
canaries10318943canaries
cannier94014163ca_nnier
caperer113013403caper_er
caponier1237883caponier
capturer1246093captur_er
carder94524183ca__rder
career85822243ca__reer
carer74942333ca__r_er
caried94528693ca__ried
caries85147623ca__ries
carper104923633ca__rper
carried103717153ca_rried
carriers103614203ca_rriers
carries94328013ca_rries
carter84932273ca__rter
carver114420143ca__rver
cashier123713323ca_shier
catbird1235243catb_ird
catbirds1344203catbirds
catcher143115823cat_cher
cater74840723cat___er
catered103117773cater_ed
caterers102814403cater_ers
catering112019903catering
catheter1338153catheter
catnaper1294933catnaper
catteries11815523catteries
cattie85221023cat_tie_
catties94023053cat_ties
cauteries11615393cauteries
cavalier1348173cavalier
cavorter1335783cavorter
charier124317903c_harier
charrier1378683charrier
chattier1337513chat_tier
cheerier1348003cheerier
chubbier1733893chubbier
clubbier1434833clubbier
cobbier133410163c_obbier
coterie9417403coterie_
coteries10422703coteries
cottier93814173cot_tier
courier93617893c_ourier
couturier1145423couturier
crabbier14326803crabbier
crier74724463c___rier
currier93316703c_urrier
cutesier1045623cutesier
dataries9314033dataries
daubier1037103daub_ier
daubries1136743daubries
eateries8324313eateries
farrier103514893fa_rrier
fattier103513463fat_tier
gabbier12379633ga_bbier
gambier124711973gamb_ier
hairier103111053ha_irier
harrier104417753ha_rrier
lambier113611643lamb_ier
lathier10310833lat_hier
marblier1256343marblier
marrier93817523ma_rrier
materiel10311253materiel
matier84321523mat__ier
maturer938973matur_er
nattier73614623nat_tier
paltrier1037523paltrier
parrier93717653pa_rrier
patchier15319663patchier
ratifier1139673ratifier
rattier74015593rat_tier
roturier836033roturier
satirizer1846463satirizer
savorier1136643savorier
scabbier1435133sca_bbier
scarier94017873sca__rier
scarrier10298453sca_rrier
scattier10267583scat_tier
starrier8279463starrier
tarrier74323173ta_rrier
tattier74216243tat_tier
tawdrier12133433tawdrier
trier54328533__t_rier
varier94619353va__rier
wabblier15375493wabblier
wamblier15275733wamblier
warier93722893wa__rier
waterer103314073water_er

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 Filter1786911461620.1601116818.8
2DLD Change Limit1461621187.50019488.3
3Display Results1181180.0462565.2
 (SQL Overall)1786911187.70623188.6
 
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.