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

264 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
untrod76985(None) 
hotrod1048802hotrod
intro54915852intro_
intron64215022intron
intros64215772intros
trod57627952__trod
unbred92613302unbred
unhood1039232unhood
unipod946852unipod
unshod1067602unshod
untied73720812untied
untired82316382untired
unto45824282unt_o_
untold7149682untold
untorn63012342untorn
untread857412untread
untried82615852untried
untrim8310682untrim
untrue6310772untrue
andro6314163andro_
android9311513android
andros7313303andros
aneroid8314003aneroid
anted66328243ant_ed
anteed75616113anteed
anthoid11313313anthoid
antired82316193antired
antra56521923antr_a
antral65719413antral
antre55224523antr_e
antres65021003antres
antrum8611313antrum
aunthood1254723aunthood
bunted95219183bunt_ed
centred103411683centred
centroid1159313centroid
citron83112983citron
control9310693control
cuatro838433cuatro_
cuatros938273cuatros
downtrod1343353downtrod
dunted84718503dunt_ed
emerod9139213emerod
enrol51014283en_rol
entered82718883entered
enteron7313343enteron
entrap8710563entrap
entree61817883entree
entropy1247353entropy
entry82414263entr_y
enured73315333enured
fantod102010033fant_od
hatred104814333hatred
hotrods1148283hotrods
hundred1237143hundred
hunted104417013hunt_ed
inbred93010403inbred
inro45920793in_ro_
inroad737933in_road
intend72310373intend
into45026153int_o_
intort6418923intort
introfy1344753introfy
introit7414533introit
introns73515023introns
intrude837403intrude
inured73114813inured
junto125114563junt_o_
juntos134110843junt_os
lunted74517523lunt_ed
lustred8359053lustred
matron83918313matron
method1239023method
metred95315143metred
metro74718803metro_
metros84217803metros
mitred94414343mitred
nard56634453_nar_d
natron64116023natron
nerd56624943_ner_d
nerol51017813_nerol
nimrod934873nimrod
nitrid72812233nitrid
nitro54914353nitro_
nitros64214123nitros
nod47549563_n__od
nurd56224343_nur_d
nutria639913nutria
nutted74316973nutted
nutwood1144953nutwood
octroi837363octroi
onto46127663ont_o_
outrode82313423outrode
outrow9311183outrow
outtrot7312613outtrot
patrol83213023patrol
patron84018043patron
petrol82714063petrol
prod76129503__prod
punted94618713punt_ed
punto75121323punt_o_
puntos85915793punt_os
pushrod1343703pushrod
putrid9311173putrid
ramrod936833ramrod
retro55020953retro_
retros63820193retros
rod47953893___rod
sarod65325873_sarod
schrod1247883schrod
scrod85115073_scrod
snared74824553snared
snood64616163sn_ood
snored74819543snored
stood65517713_stood
strode75215973_strode
strop77422243_strop
stroud7310383_stroud
strow88920573_strow
stroy87720393_stroy
tetrad73612053tetrad
tetrode839343tetrode
tod49457073__t_od
trad55630913__trad
trode65322853__trode
trog57628213__trog
trop66833303__trop
trot46351313__trot
trow78031423__trow
troy77429683__troy
ultra539363ultr_a
ultras6310193ultras
unaged83916423unaged
unaired82916013unaired
unarm7314453unar_m
unarmed101811923unarmed
unarms839243unarms
unary8315993unar_y
unawed103914903unawed
unaxed144113093unaxed
unbend9269773unbend
unbid83214643un_bid
unbind93011433unbind
unborn83310813unborn
unbox1438753un_box
unbraid1037183unbraid
unbroke13217743unbroke
unclad938913unclad
unclog956603unclog
uncloud1046433uncloud
unco66021403un_co_
uncool8610113uncool
uncork1239043uncork
uncos74117033un_cos
uncoy104111413un_coy
uncross938193uncross
uncrown1236323uncrown
unction9310663unction
uncured10513233uncured
undead82711903undead
underdo937363underdo
undergod1136583undergod
undid72415363un_did
undo55620153un_do_
undraw1037813undraw
undrew1037913undrew
undried92314613undried
undyed1138143undyed
unfed94614223un_fed
unfired112212453unfired
unfold10179703unfold
unfond10149113unfond
unfree9413203unfree
unfreed11510123unfreed
unfrock1674633unfrock
unfroze1945413unfroze
ungird887973ungird
ungot61718063un_got
unground1044853unground
unhand10410383unhand
unhired112512153unhired
unhoods1137503unhoods
unhook1347523unhook
unibody1343353unibody
union54519793un_ion
unipods1095703unipods
unironed939083unironed
unison649033unison
unitard838003unitard
united74421543united
unkend11309223unkend
unkind113310573unkind
unknot1037413unknot
unlaid7311753unlaid
unlead73312373unlead
unled64021073un_led
unload73010803unload
unmitred1136843unmitred
unmold9148313unmold
unmoor836313unmoor
unpaid939473unpaid
unprobed1366973unprobed
unproved1457533unproved
unread73412673unread
unrig61711413un_rig
unrip72012863un_rip
unrobe82611673un_robe
unrobed102711213un_robed
unroll61210073un_roll
unroof9410193unroof
unroot6315553unroot
unroped102812103un_roped
unround8138503un_round
unrove92511683un_rove
unsaid7411833unsaid
unshed10313773unshed
unsold71410513unsold
unstop837473unstop
unstrap946783unstrap
untack1239763untack
untame82513603untame
untamed102913223untamed
untaxed152710583untaxed
unthread1244603unthread
unthrone11128183unthrone
unthroned13106223unthroned
untidy1059153untidy
untie54425493unt_ie
unties64326923unties
until53517743unt_il
untimed102713373untimed
untraced112413243untraced
untrack1338703untrack
untreads936223untreads
untrendy1243483untrendy
untrims938613untrims
untrodden1142973untrodden
untruer737113untruer
untruly1046293untruly
untruss736553untruss
untruth1045353untruth
untuck1236403untuck
untune62511603untune
untuned82010823untuned
unturned9228563unturned
unurged939143unurged
unused72012883unused
unwed94114873un_wed
unwind102610543unwind
unwon84512343un_won
unwooed11229773unwooed
unworn93411333unworn
unwrap11126323unwrap
upgrow1234273upgrow
uphroe1136083uphroe
upprop944093upprop
upstood1044243upstood
upthrow1543193upthrow
uptore8279453uptore
uptorn8268093uptorn
uptrend1044293uptrend
urd46427053u__r_d
uropod937263uropod
uttered82712433uttered

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 Filter1786911127160.376475242.0
2DLD Change Limit1127162645.86019234.8
3Display Results2642640.0763473.7
 (SQL Overall)1786912646.31228309.7
 
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.