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

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

129 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
bathe10582288(None) 
bate66552421bat_e
bath95940081bath_
bathed125518741bathed
bather115322511bather
bathes116524831bathes
baths105922921baths
lathe85626711lathe
rathe85821921rathe
abate76627842abat_e
ache96829822_ache
ate37059242_at_e
babe86835812ba_be
bach116131392bach_
bached145519892bached
baches135426942baches
bade75140882ba_de
badge94819682badge
bah87755352ba_h_
baht96740012ba_ht
bahts105617802bahts
baith108023132baith_
baize164717392baize
bake105637512ba_ke
bale66353842ba_le
bane65250422ba_ne
barbe95328282barbe
barde85330772barde
bare65460522ba_re
barge85631022barge
barre75929542barre
barye105021492barye
base64847022ba_se
bash915240162bash_
bashed126225702bashed
basher115123812basher
bashes115631392bashes
baste74829982baste
bat510988952bat__
batch124620102batch
batched154114242batched
batcher144414852batcher
batches144019612batches
bated85935532bated
bates75846342bates
bathers124720362bathers
bathos116215632bathos
batik11614732batik
batmen104414302batmen
baton75822422baton
bats66962332bat_s
batt65053872bat_t
batted95623652batted
batten85217122batten
batter84928872batter
battle85217862battle
batts76727562batts
battu75216612battu
battue84311002battue
batty105422242batty
bawtie113812142bawtie
beth96629232beth_
bethel1169642bethel
beths105519222beths
bite66546992bit_e
blate75933782blat_e
blather125314202blather
blithe115810862blithe
boche124216952boche
both96533432both_
bother115218062bother
bothy136713962bothy
breathe123711842breathe
bute66739672but_e
butle75023102butle
butte74924292butte
byte96521812byt_e
cache125122482cache
cate66254592cat_e
date56443322dat_e
eath75735662eath_
fate75444282fat_e
father125116712father
gate55746572gat_e
gather104115852gather
hate78450172hat_e
hath105933912hath_
kithe125917452kithe
kythe15509672kythe
late47560482lat_e
lath76640382lath_
lathed104718452lathed
lather95124352lather
lathes95127492lathes
lathi85417202lathi
laths86022402laths
lathy115215062lathy
latke94817092latke
latte55426302latte
lethe85717302lethe
lithe84922012lithe
loathe94211382loathe
mache125925302mache
mate65154212mat_e
math95437442math_
maths105624022maths
matte75626842matte
oath76132152oath_
oaths86117312oaths
pate65350462pat_e
path99134912path_
paths105521382paths
raphe104916422raphe
rate45458762rat_e
rath76037662rath_
rather94319732rather
sadhe94815132sadhe
saithe94713912saithe
sate45556102sat_e
scathe114414992scathe
snathe94415112snathe
spathe115115692spathe
swathe125514112swathe
tache106222372tache
tate44748602tat_e
the67436052__the
tithe85319702tithe
tythe115210452tythe
withe115220232withe

Search took 3 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 Filter178691538000.0931921408.6
2DLD Change Limit538001291.87628678.0
3Display Results1291290.0462804.3
 (SQL Overall)1786911292.01588680.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.