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

155 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
inroads83704(None) 
inroad737931inroad_
broads94515152_broads
byroads1335292byroads
inboards1145842inboards
infolds11137022infolds
onloads8246672onloads
roads66523622__roads
unloads8278522unloads
abroad9310943abroad_
androids1047753androids
aneroids9310203aneroids
anoas57226493an_oa_s
anoraks1137603anoraks
aroids75118223_aroids
brads85528293_br_ads
breads95419203_breads
broad84817693_broad_
broods95416383_broods
byroad1236623byroad_
carloads1138393carloads
croaks125812983_croaks
crowds124910763_crowds
dreads84115023_dreads
droids84712583_droids
dryads11436623_dryads
enfolds11136253enfolds
enneads834733enneads
enrobes92211113enrobes
enrolls7108093enrolls
enrols61213383enro_ls
enroots738713enroots
farads104713273far_ads
fibroids1445843fibroids
fronds106412343_fronds
goads77022853__goads
grads75625753_gr_ads
groans74815063_groans
groats74816653_groats
highroads1743363highroads
ihrams1137173ihr_ams
iliads7448673i_liads
inboard1037063inboard
inbounds11134053inbounds
inbreds10245733inbreds
inbreeds11234623inbreeds
incogs937903inco_gs
incomes11712373incomes
incross937663incro_ss
indoles83716363indoles
indols74714203indo_ls
indoors838553indoors
indows104210793indo_ws
infold10128163infold_
informs1248073informs
infos84311673info__s
ingots7912063ingo_ts
ingroups1143483ingroups
inions64417003inio_ns
inkwoods1674083inkwoods
inlands838783inlands
inlays9389873in_lays
innards837153innards
inpours936423inpours
inro45920793inro___
inruns6359513inr_uns
inseams9307903inseams
insoles73516243insoles
insouls737213insouls
inspans937803inspans
instals7611713instals
instars7411133instars
intends8239963intends
intombs1144153intombs
intones7816543intones
intorts7310973intorts
intrados946563intrados
intreats8311543intreats
introits859713introits
introns73515023intro_ns
intros64215773intro__s
invade10157853in_vade
invades11118293in_vades
invars9310003in_vars
invokes1436383invokes
inwards1138343inwards
inwinds11216273inwinds
inwraps12105253inwraps
irade65618153i_r_ade
irades74517393i_r_ades
irids66417773i_r_ids
irokos1037233i_rokos
irones64724013i_rones
irons55324133i_ro_ns
ixoras1337193ixora_s
kilorads1344423kilorads
kneads11357093kn_eads
lipreads1144223lipreads
loads65323373__loads
misreads11268923misreads
myriads1334353myriads
naiads739013_naiads
nicads938333_nicads
nimrods1044283nimro_ds
nods55838223_n_o_ds
nomads94711603_nomads
ogdoads1042993ogdoads
onload7268633onload_
oreads73915773_oreads
pinfolds1445143pinfolds
pinheads14336243pinheads
proas75028803_proa_s
prods85523553_pro_ds
rads56046603__r_ads
railroads1043523railroads
reads64835273__reads
reloads8911313reloads
rereads81512293rereads
road56332113__road_
roams74919613__roams
roans54926443__roans
roars55622243__roars
rods56442063__ro_ds
roods65125283__roods
sarods74918573saro_ds
scrods94111603scro_ds
shrouds1136023shrouds
snoods74312453sn_oods
spreads1039763spreads
strouds837803strouds
threads11419953threads
throats104612193throats
toads65621073__toads
toroids8310643toroids
treads74817923_treads
triads74513533_triads
troaks104410603_troaks
unfolds11146803unfolds
unhoods1137503unhoods
unleads8228623unleads
unload73010803unload_
unmolds10135743unmolds
unread73412673unread_
unready11215943unready
unrobes9269733unrobes
unrolls797793unrolls
unroofs1035783unroofs
unroots738563unroots
unrounds9145573unrounds
untreads936223untreads
uploads10266503uploads
uproars986453uproars
vanloads1264163vanloads
viroids1137923viroids
woads94818443__woads

Search took 10 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 Filter1786911340270.300595636.7
2DLD Change Limit1340271559.42014227.9
3Display Results1551550.0463369.6
 (SQL Overall)1786911559.76618297.3
 
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.