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

145 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
chertiest143879(None) 
chestiest1438311chestiest
chariest13315502char_iest
charriest1438252charriest
chartist131112132charti_st
chattiest1448202chattiest
cheekiest1835702cheekiest
cheeriest1438212cheeriest
cheesiest1436322cheesiest
cherries131812982cherries_
chertier1387872chertie_r
chewiest16177292che_wiest
chirpiest16286472chirpiest
heartiest12311102_heartiest
heftiest1439182_heftiest
herbiest1339992_herbiest
shirtiest1239322shirtiest
aeriest73924053_aer_iest
alertest8310173alert_est
artiest73121993__artiest
beeriest104013403beer_iest
carrotiest1245663carrotiest
cattiest103016333c_attiest
cerites94823433c_erites_
certainest1248863c_ertainest
certes84623083c_ert_es_
chaffiest2045413chaffiest
chalkiest1837083chalkiest
chanciest1638373chanciest
chanties132615803chanties_
charities14312743charities_
charlies133414233charlies_
chartists14126803charti_sts
chartless1435703chartless
chastest1349703chast_est
cheapest1536073che_apest
cheapies1539033cheapies_
chedites1438263chedites_
chemist143615003che_mi_st
cherish15310463cher_i_sh
cherts115617233chert__s_
chervils1644553chervils_
chestier1387423chestie_r
chevies153511443che_vies_
chichiest1936343chichiest
chilliest14358913chilliest
chinkiest1867023chinkiest
chintziest2443253chintziest
chippiest18256803chippiest
chirkest1735383chir_kest
chitties13310773chitties_
chokiest1738723ch_okiest
choosiest1437323choosiest
choppiest18226373choppiest
chortles133611323chortles_
chromiest1637783chromiest
chubbiest1843753chubbiest
chuffiest2044403chuffiest
chummiest1834643chummiest
chunkiest1835263chunkiest
churchiest2044053churchiest
chutist1239453ch_uti_st
clergies1137903clergies_
clerkliest1642793clerkliest
corkiest143114793c_orkiest
corniest102117303c_orniest
courtliest1244903courtliest
craftiest1436913craftiest
creakiest15238593creakiest
creamiest13248933creamiest
creasiest11229943creasiest
creepiest1337063creepiest
crepiest12310383cre_piest
crustiest112410053crustiest
curdiest112511393c_urdiest
curliest102713123c_urliest
curtest9713963c_urt_est
curviest13309673c_urviest
dirtiest93014203_dirtiest
eeriest73620673_eer_iest
ferniest1132214153_ferniest
fieriest112112243fier_iest
flirtiest1236193flirtiest
frettiest1267063frettiest
germiest11249913_germiest
ghostiest1336543ghostiest
gleetiest1035913gleetiest
hardiest123416333_hardiest
hastiest112916493_hastiest
headiest123015553_headiest
hearties11315413_hearties_
heathiest1549383_heathiest
heaviest143210443_heaviest
hedgiest13298133_hedgiest
hempiest1539023_hempiest
herries104025073_herries_
hertzes1938303_hertzes_
hootiest113115643_hootiest
horniest112814043_horniest
horsiest112513263_horsiest
jerkiest19328113_jerkiest
jettiest15359593_jettiest
leeriest83112883leer_iest
meatiest102816793_meatiest
merriest10311473_merriest
nerdiest92511163_nerdiest
nerviest11188833_nerviest
nettiest83112433_nettiest
oneriest8313443oner_iest
peatiest103118803_peatiest
perkiest143313243_perkiest
pertest9317043_pert_est
pestiest103018413_pestiest
pettiest103113963_pettiest
prettiest1199803prettiest
purtiest102414113_purtiest
rheumiest1442863rheumiest
sheeniest12158353sheeniest
shelliest1238023shelliest
shelties111111383shelties_
shelviest1535003shelviest
sherries111812893sherries_
shiftiest1537363shiftiest
shittiest1238333shittiest
shortest11310783short_est
shorties11414583shorties_
sleetiest938553sleetiest
spheriest1438373spher_iest
sportiest111711023sportiest
sweatiest1238413sweatiest
tartiest82718313_tartiest
tentiest82115613_tentiest
testiest82715223_testiest
thewiest14196343the_wiest
thirstiest1343973thirstiest
thirties1139723thirties_
thorniest1236483thorniest
veriest103719133_ver_iest
wartiest113614643_wartiest
wheeziest2443663wheeziest
whelkiest1943963whelkiest
wherries14179023wherries_
whirliest15216043whirliest
whitiest14259883wh_itiest
zestiest173011103_zestiest

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 Filter1786911486410.1731032896.0
2DLD Change Limit1486411456.70322175.3
3Display Results1451450.0801812.5
 (SQL Overall)1786911456.95625688.8
 
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.