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

214 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
innards83715(None) 
inwards1138341inwards
canards10311202canards
inarms8410092i_narms
inboards1145842inboards
infares10313022infares
inlands838782inlands
innages82911302innages
inners63919352inner_s
insnares858082insnares
invars9310002invar_s
inward10310332inward_
izzards16143962izzards
nards65928462__nards
onwards1137172onwards
anears63717183anear_s
annals66415923anna_ls
annas55824883anna__s
annates72415423annates
awards107113453_awards
bards87139643__bards
bayards13379683bayards
beards94116673_beards
blinkards1642723blinkards
boards94616933_boards
boyards13399323boyards
briards10398553briards
canard9314763canard_
cards85137933__cards
chards125119723_chards
cowards1339613cowards
denars74621433denar_s
diehards1346213diehards
dinars75417563dinar_s
dinners83915443dinner_s
discards1238913discards
dotards937253dotards
echards1337963echards
engirds995053engirds
enneads834733enneads
ensnares856893ensnares
ensnarls873393ensnarls
fards96629843__fards
finmarks17154463finmarks
finnmarks18122043finnmarks
ginners84314223ginner_s
gizzards18133263gizzards
gnarls74210773_gnarls
gnarrs7407663_gnarrs
gnars66718853_gnar_s
gonads84511733gona_ds
guards84611563_guards
gurnards1043633gurnards
hards96435653__hards
hazards2037463hazards
hoards104912623_hoards
holards1148433holards
ignores8269003ignores
iliads7448673ilia_ds
imbarks15326613imbarks
imparks15276663imparks
imparts11298533imparts
inanes62519803i_nanes
inarch1139163i_narch
inarm7314423i_nar_m
inboard1037063inboard_
inbreds10245733inbreds
incages103013883incages
incants92012803incants
incases93615973incases
incurs83012273incur_s
indabas1045843indabas
indris7311953i_ndris
inearth1037033inearth
inearths1144933inearths
inerts64517023i_nerts
infalls1038943infalls
infants102210773infants
infarct1249013infarct
infarcts1345233infarcts
infare9313083infar_e
infers93615443infer_s
infirms1245563infirms
infolds11137023infolds
informs1248063informs
infrareds1342583infrareds
ingates82716893ingates
inhales10511863inhales
inhauls1035513inhauls
inheres10315173inheres
injures143111173injures
inkers104018833inker_s
inlaces92512903inlaces
inlaid7310133inlaid_
inland7310313inland_
inlays9389873inla_ys
inmates92715763inmates
innage73011573inna_ge
innate63917313inna_te
inned64118423inn_ed_
inner54920633inner__
innerly1037133innerly
innerve1056743innerve
innerves1158013innerves
innings8329443innings
innless7288293innless
inns46920933inn___s
inroads837043inroads
inserts74013993inserts
insnare748243insnar_e
insnared956123insnared
insnarer865303insnarer
insnarers954433insnarers
instars7411113instar_s
insureds9277613insureds
insures73117263insures
intakes11310943intakes
intends8239963intends
interns73116763interns
inters64328043inter_s
intorts7310963intorts
intrados946563intrados
intros64215773i_ntros
inturns73210133inturns
inures63318953i_nures
inurns63310983i_nurns
invade10157853inva_de
invades11118293invades
invalids1244733invalids
invar839513invar__
inverts103211953inverts
inwalls1037283inwalls
inwardly1543783inwardly
inwinds11216273inwinds
inwraps12105253inwraps
islands837323islands
izars145112933i_zar_s
izzard15135243izzard_
kinaras1159093kinaras
knars94416113_knar_s
kneads11357093knea_ds
laniards967313laniards
lanyards1266393lanyards
lards65331863__lards
liards75212613_liards
lizards17427613lizards
lunars65012813lunar_s
mansards1148013mansards
manwards1447613manwards
mazards1937703mazards
menads95514383mena_ds
monads94515303mona_ds
monarda1046613monarda
monardas1145703monardas
narcs76122023__narcs
nard56634453__nard_
nares55544153__nares
naris55735293__naris
narks96026033__narks
nears55529423_near_s
nerds65719253__nerds
nicads938333nica_ds
niggards1144113niggards
nonarts7311303nonarts
nurds65518523__nurds
onward1039053onward_
pards85634333__pards
petards104311153petards
pinnaces12268863pinnaces
pinnas85315513pinna__s
pinners93518603pinner_s
poniards1145823poniards
qindars17267423qindar_s
qintars16268573qintar_s
regards94112563regards
retards85015003retards
rewards114813993rewards
reynards1244303reynards
ritards8439943ritards
sards64736183__sards
shards104319173_shards
sinners74019023sinner_s
snares65329033_snares
snarfs95113423_snarfs
snarks104815733_snarks
snarls64016873_snarls
sonars64818973sonar_s
stinkards1443553stinkards
sunwards1236443sunwards
swards105415133_swards
tabards10310383tabards
tankards1366253tankards
tanyards1276183tanyards
tinners73717313tinner_s
tinwares1137903tinwares
towards1138783towards
unarms839243_unarms
unbars82113033unbar_s
ungirds9105303ungirds
unguards1053983unguards
unhands1137773unhands
unitards945623unitards
unnails738223unnails
unsnarls894883unsnarls
upwards13135963upwards
vawards14457573vawards
vineyards1643223vineyards
visards11328153visards
vizards20377263vizards
wards97734403__wards
windwards1764513windwards
winners104316913winner_s
wizards20326403wizards
yards95324613__yards

Search took 9 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.313570897.8
2DLD Change Limit1340272147.70317399.3
3Display Results2142140.0762815.8
 (SQL Overall)1786912148.09222082.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.