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

88 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
haricots134733(None) 
haricot12311961haricot_
apricots1275392apricots
chariots1339392chari_ots
haircuts1343662haircuts
harlots103413292har_lots
heriots10312062heri_ots
tricots9311562_tricots
apricot111010183apricot_
argots74116033_ar_gots
aristos7312373_aristos
ascots85312513_a_scots
calicoes123911603calicoes
calicos113913493calico_s
caracols12310413caracols
caribous1258823caribous
carices114220953caric_es
cariocas1239663cariocas
carious93320283cari_ous
carrots9714623car_rots
chariot12316213chari_ot_
darics94314113daric__s
dicots94915793__dicots
earshots1146623earshots
galiots82311323gali_ots
galipots1145213galipots
garcons102411643gar_cons
griots74713643_gri_ots
habitats1346733habitats
habits113014653habi__ts
haints94417583ha_i_nts
haircaps15144363haircaps
haircloth1752983haircloth
haircloths1852463haircloths
haircut1246833haircut_
hairdos1136823hairdo_s
hairnets1195633hairnets
halibuts1364443halibuts
halidoms1485823halidoms
harbors12412413har_bors
hardboots1544353hardboots
hardcore1446053hardcore
hardcores1545983hardcores
hardhats1546833hardhats
hardtops1444843hardtops
harianas1139163harianas
harijans1845723harijans
harissas1145983harissas
harlot94422803har_lot_
harpists1338103harpists
harpoons1337483harpoons
harrows132611033har_rows
harslets1137833harslets
harts88441593har___ts
harvests14246173harvests
haviors1347383havi_ors
hayricks2043763hayric_ks
helicons1337613helicons
helicopts1643803helicopts
heriot9422343heri_ot_
heritors11310903heritors
horizons2045463horizons
lariats7615053lari_ats
lyricons1343583lyricons
manihots13126443manihots
marmots11311513mar_mots
marplots1245633marplots
mascots113910343ma_scots
massicots1343843massicots
maxicoats2042863maxicoats
narcists1078113narcists
narcos86714203nar_co_s
parrots9312743par_rots
patriots1038053patri_ots
peridots1138323peridots
picots104616443__picots
riots54922013__ri_ots
sarcous9312933sar_cous
talipots1045623talipots
tarots66422993tar__ots
tricot8317753_tricot_
variants1139203variants
varices123313573varic_es
varicose1346703varicose
varicoses1446653varicoses
varicosis1445023varicosis
various103113103vari_ous
warisons1136903warisons

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.436409841.7
2DLD Change Limit146162887.05020732.2
3Display Results88880.0461913.0
 (SQL Overall)178691887.53223724.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.