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

221 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
inroad73793(None) 
inroads837041inroads
abroad9310942abroad
broad84817692_broad
byroad1236622byroad
inboard1037062inboard
infold10128162infold
inro45920792inro__
onload7268632onload
road56332112__road
unload73010802unload
unread73412672unread
android9311513android
aneroid8314003aneroid
anoa45634473an_oa_
anoas57226493an_oas
anorak1038923anorak
aroid65428343_aroid
brad75234343_br_ad
bread85523113_bread
broads94515153_broads
brood84620243_brood
byroads1335293byroads
carload1039783carload
croak115216633_croak
crowd115815623_crowd
dorsad8408973dorsad
dread74419023_dread
droid74218543_droid
dryad10477583_dryad
enfold10137613enfold
ennead736253ennead
enrobe86610793enrobe
enrobed10279253enrobed
enrol51014283enro_l
enroll61110073enroll
enrols61213383enrols
enroot6615993enroot
farad95720673far_ad
fibroid1337243fibroid
forbad122710503forbad
frond95316343_frond
goad66830983__goad
grad66829863_gr_ad
groan65618423_groan
groat65531973_groat
highroad1643703highroad
ignored9226443ignored
ihram10310183ihr_am
iliad64613463i_liad
inarmed10268673inarmed
inboards1145843inboards
inborn8319143inborn
inbound10115773inbound
inbred93010403inbred
inbreed10267643inbreed
inched124514483inched
incog838253inco_g
incogs937903incogs
income10712093income
incony1139083incony
incross937663incross
indeed83913563indeed
indol63714873indo_l
indole74516053indole
indols74714203indols
indoor738403indoor
indow95011663indo_w
indowed1237443indowed
indows104210793indows
indued83411653indued
info75617353info__
infolds11137023infolds
inform11310153inform
infos84311673info_s
infra838643infra_
ingot61221063ingo_t
ingoted939183ingoted
ingots7912063ingots
inground1044383inground
ingroup1044333ingroup
ingrown1145393ingrown
inia45024703in_ia_
inion54620183inio_n
inions64417003inions
inked104218523in_ked
inkwood1584533inkwood
inlaid7310143inlaid
inland7310313inland
inlay85214323in_lay
inmost8411363inmost
inned64118423in_ned
inpour837063inpour
inrun52911373inr_un
inruns6359513inruns
inrush936513inrush
inseam8329993inseam
insofar1043543insofar
insole63515863insole
insoul638463insoul
inspan837513inspan
instal6712193instal
instar6310013instar
instead836203instead
intend72310373intend
into45026153into__
intomb1036403intomb
intone61115433intone
intoned8811993intoned
intort6418923intort
intown936153intown
intreat7416303intreat
intro54915853intro__
introfy1344753introfy
introit7414533introit
intron64215023intro_n
introns73515023introns
intros64215773intro_s
inured73114813inured
inurned8328053inurned
invade10157853in_vade
invar839513in_var
invoke1336213invoke
invoked1535303invoked
inward10310333inward
inwind10268413inwind
inwound11134973inwound
inwove12167273inwove
inwrap11115903inwrap
irade65618153i_r_ade
ired55131873i_r_ed
irid55927173i_r_id
irked104510923i_rked
iroko939663i_roko
iron46728463i_ro_n
irone55126363i_rone
ironed74916013i_roned
irons55324133i_rons
irony85015903i_rony
irreal657833irreal
ixora1236913ixora_
ixoras1337193ixoras
kilorad1245393kilorad
knead10429663kn_ead
lipread1034953lipread
load56730603__load
minored10310103minored
misread10339723misread
myriad1235913myriad
naiad6313403_naiad
nicad8312613_nicad
nimrod934873nimro_d
nod47549563_n_o_d
nomad86016183_nomad
ogdoad943523ogdoad
onboard1046503onboard
onloads8246673onloads
orad56031693_or_ad
oread64619603_oread
pinfold1336233pinfold
pinhead13347073pinhead
proa66229963_proa_
proas75028803_proas
prod76129503_pro_d
proud84615483_proud
rad47662003__r_ad
railroad943803railroad
read55942533__read
reload7413893reload
reread71715433reread
roads66523623__roads
roam67132413__roam
roan47234203__roan
roar46328573__roar
rod47953893__ro_d
rood56733003__rood
sarod65325873saro_d
scrod85115073scro_d
shroud1038773shroud
snood64616163sn_ood
snored74819543snored
spread9312533spread
stroud7310383stroud
thread105011093thread
throat94819753throat
toad55830183__toad
toroid7416013toroid
trad55630913_tr_ad
tread64821703_tread
triad65217723_triad
troak95213573_troak
trod57627953_tro_d
unclad938913unclad
undead82711903undead
unfold10179703unfold
unfond10149113unfond
unhood1039233unhood
unlead73312373unlead
unloads8278523unloads
unmold9148313unmold
unready11215943unready
unreal64414453unreal
unrobe82611673unrobe
unrobed102711213unrobed
unroll61210073unroll
unroof9410193unroof
unroot6315553unroot
unroped102812103unroped
unround8138503unround
unrove92511683unrove
unsold71410513unsold
untold7149683untold
untread857413untread
untrod769853untro_d
upload9257783upload
uproar8106933uproar
vanload1144703vanload
viroid10411523viroid
woad85523943__woad
zeroed16409413zeroed
zincoid1946663zincoid

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.373479064.3
2DLD Change Limit1127162215.47020606.2
3Display Results2212210.0633507.9
 (SQL Overall)1786912215.90630255.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.