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

168 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
tuxedo143313(None) 
tuxedos1543291tuxedos
taxed135620292taxed_
teredo7310782teredo
toledo7419992toledo
tubed85818042tubed_
tuned64622312tuned_
tupelo836482tupelo
tuxedoed1741742tuxedoed
tuxedoes1642752tuxedoes
tuxes124316042tuxe_s
uredo65112992_uredo
albedo956123albedo
axed128829613_axed_
boxed154318613boxed_
bruxed16466983bruxed_
bused85624493bused_
buteo75419893bute_o
comedo11359603comedo
coxed154322813coxed_
credo84815563_credo
cubed105519703cubed_
cued76329563cu_ed_
cured85932133cured_
duded84417133duded_
duked115218463duked_
dukedom1542773dukedom
duped95118323duped_
dured75025403dured_
exed125420593_exed_
faxed166220533faxed_
fixed165416953fixed_
fluxed17509673fluxed_
foredo10510823foredo
foxed165115213foxed_
fumed116118823fumed_
fused94820443fused_
fuzed185415253fuzed_
guyed1049893guyed_
hexed165615763hexed_
hued86925853hu_ed_
judo125315303ju__do
juked175714073juked_
kudo96115103ku__do
loxed135017053loxed_
lubed85319893lubed_
luged74019093luged_
lured65427493lured_
luted64826143luted_
luxe115222693luxe__
luxes124921503luxe_s
maxed155821193maxed_
mixed155717253mixed_
muled85824433muled_
mured85726703mured_
mused85524583mused_
muted85023383muted_
nixed135714223nixed_
nuked104014183nuked_
outdo6312703ou_tdo
outed65429063outed_
poxed154817863poxed_
puked124716223puked_
puled84926523puled_
pumelo10257113pumelo
raxed135622663raxed_
redo56029363__redo
rued55729793ru_ed_
ruled65822523ruled_
sexed136618543sexed_
speedo94011993speedo
sued56537933su_ed_
suede64419753su_ede
tamed85528513tamed_
taped85327423taped_
tardo65321103t_ardo
tared69340053tared_
tauted75317113tauted_
tawed95926193tawed_
taxeme1536253taxeme
taxer125019363taxe_r
taxers134015283taxers
taxes124730823taxe_s
taxied14509373taxied_
ted46446563t__ed_
teds54932573t__eds
teed55439263t_eed_
teledu737303teledu
teredos839173teredos
tewed94718533tewed_
tided76322513tided_
tied55535213t_ied_
tiled64832943tiled_
timed85223613timed_
tined65434533tined_
tired65228903tired_
toed56137043t_oed_
toked105626493toked_
toled65934923toled_
toledos8388863toledos
tondo69718683t_ondo
toned65435343toned_
toped85631313toped_
torero6313203torero
torpedo1035053torpedo
toted64929483toted_
toured74216153toured_
toused74122013toused_
touted74419743touted_
towed95134583towed_
toyed96019803toyed_
treed65626733treed_
tried65026913tried_
truced95312053truced_
trued65117693trued_
tsked105910033tsked_
tubbed114712223tubbed_
tube65828663tube__
tuber75420683tube_r
tubers85017033tubers
tubes74826453tube_s
tucked134017493tucked_
tufted10359283tufted_
tugged93813523tugged_
tuladi765723tuladi
tule45735873tule__
tules54532793tule_s
tumefy1434223tumefy
tumid84114023tumid_
tumped114216233tumped_
tune45635863tune__
tuner56022683tune_r
tuners64417343tuners
tunes55332193tune_s
tuneup835203tuneup
tunned74014493tunned_
tupelos936113tupelos
tupped114013233tupped_
turaco839453turaco
turbo71015043tu_rbo
turd56027623tu_rd_
turds65021693tu_rds
tureen63312723tureen
turfed103110963turfed_
turned73914473turned_
tushed104615893tushed_
tusked114112153tusked_
tutee5423523tute_e
tutees6514553tutees
tutted75117443tutted_
tutued7349413tutued_
tux105426573tux___
tuyer85414293tuye_r
tuyere9408613tuyere
tuyers94612563tuyers
tweed94915093tweed_
tweeds10498433tweeds
tweedy13455933tweedy
tyned95915013tyned_
typed115815453typed_
tyred95816433tyred_
udo49027303_u__do
undo55620153_u_ndo
updo76712883_u_pdo
uredos73910623_uredos
used55722823_used_
vexed165713113vexed_
waxed166018483waxed_

Search took 6 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127161685.67319868.9
3Display Results1681680.0463652.2
 (SQL Overall)1786911685.85930498.5
 
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.