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

228 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
deraign93657(None) 
deraigns1034881deraigns
arraign845062arraign
deign74312802de__ign
deraigned1244092deraigned
derail74218812derai_l
derails84216392derails
derange939812derange
derating103222282derating
design8408932de_sign
detain74617382detai_n
detrain8412252detrai_n
drain65222892d_rai_n
aerating92821003aerating
aeration8319933aeration
arraigns944353arraigns
bearing103624773bearing
benign938313be_nign
beraking153612973beraking
berating113220763berating
berlin83116373berli_n
berming123614833berming
brain76229383_brai_n
ceratin93020163ceratin
cering94522533cer_ing
certain92612213certai_n
coreign1037343coreign
daring84928683dar_ing
darking134217343darking
darling93418363darling
darning93817333darning
darting94020663darting
deacon9510423de_acon
deaden83714323de_aden
deafen10389673de_afen
deair65817193de_ai_r
deairs74013783de_airs
dealing94323233dealing
dean56039483de_a__n
deaning94020473deaning
dearie73319813deari_e
dearies83526273dearies
deaving123814753deaving
debag94212303deba_g_
debags104211063deba_gs
debasing12238063debasing
debating123213733debating
decagon1135863decagon
decaying15239453decaying
decking153915593decking
decrying15237413decrying
deeding103315123deeding
deeming113913123deeming
defacing15238683defacing
defaming15238463defaming
defang1137753defang_
defangs1235363defangs
defrag1136463defra_g_
defrags1236193defra_gs
defraying1735853defraying
defying15328823defying
degage92711383dega_ge
degrading13137373degrading
deicing11312193deicing
deigns8389983de__igns
dekeing13358353dekeing
deking125614553de_king
delaine8314793delaine
delating103119603delating
delation92318083delation
delaying133210973delaying
deleing93313953deleing
delving123711573delving
demoing11311753demoing
denning93515173denning
dentin73919573denti_n
denting94422183denting
denying123711293denying
depaint10314593depaint
depraving1635973depraving
deraigning1344103deraigning
derailed102410403derailed
derailing112011313derailing
deranged1137693deranged
deranger1037353deranger
deranges1039973deranges
deranging1238063deranging
derat65044083dera__t
derate74531233dera_te
derated93623503derated
derates84028893derates
derats74625063dera_ts
deratting1139513deratting
deray95024183dera__y
derays105514253dera_ys
derbies103016053derbies
deride84420033der_ide
deriding112512933deriding
derision939073derision
derive103817043der_ive
deriving132510743deriving
dermic114511913dermi_c
dermis94717163dermi_s
dernier83011943dernier
derrick1435803derrick
derries83124623derries
derris73615273derri_s
dervish1436983dervish
designs9328313de_signs
destain8412083destai_n
detail74516433detai_l
details84214043details
detains83716093detains
detrains9411763detrains
deucing1139393deucing
devein1039143devei_n
dewan95718043dewa__n
dewaxing20215293dewaxing
dewing114115703de_wing
dirking133812603dirking
dirling93316073dirling
domain9511323domai_n
dormin9312313dormi_n
drag64825053d_ra_g_
draggy12346823d_raggy
dragon838843d_ragon
drags75521113d_ra_gs
drail65020973d_rai_l
drails74716953d_rails
drains73719403d_rains
draping114213353d_raping
drawing123812053d_rawing
drawn95614243d_ra_wn
draying123813843d_raying
dreading113712803dreading
dreaming124011063dreaming
dreeing94311183dreeing
dreigh11246443d_reigh
drying113411603d_rying
duramen1096903duramen
duration9312693duration
durian7312003dur_ian
during84419403dur_ing
durion7510963dur_ion
durning93511733durning
earing75235483_earing
elain55324703_elai_n
eloign7456983_eloign
ensign737523_ensign
erasing8317963_erasing
erasion7311963_erasion
erring73816483_erring
fearing113520033fearing
feign94210713fe__ign
fermion1236763fermion
foreign1136833foreign
gearing92818843gearing
grain65126253_grai_n
hearing113324163hearing
herding122915123herding
herein93717793herei_n
heroin94420593heroi_n
herring113615883herring
jerkin17258113jerki_n
jerking19308923jerking
keratin113314153keratin
kerbing14308483kerbing
kerfing15307533kerfing
kerning124010893kerning
merging112711763merging
merlin83916683merli_n
nearing83020333nearing
nerving112910833nerving
pereion9312053pereion
perigon1039853per_igon
perking143716463perking
permian112612283permian
perming123416093perming
pertain92714963pertai_n
rain46251733__rai_n
reagin74915533re_agin
realign838763realign
rearing83128783rearing
refrain10310043refrai_n
regain74517763regai_n
reign65015193__reign
remain85919863remai_n
reraise7316313reraise
reran57329103rera__n
rerig64018483rer_ig_
rerigs74014793rer_igs
resign74212583re_sign
retain64523283retai_n
retrain7615423retrai_n
scraigh1335673scraigh
searing83330923searing
serai56830163serai__
serail64222673serai_l
serails73318363serails
serais64326133serai_s
serein63318463serei_n
serging93416673serging
serin55434443ser_i_n
sering74731813ser_ing
serpigo1044833serpigo
serving113014983serving
sprain83614863sprai_n
strain64919573strai_n
tearing84021493tearing
terai53525483terai__
terais64023513terai_s
terming104016003terming
ternion739493ternion
terrain7410853terrai_n
tertian7511193tertian
train56529113_trai_n
undersign1177113undersign
verdin103113023verdi_n
verging123812303verging
vermian12329713vermian
vermin113414523vermi_n
versing112314193versing
version10310923version
vertigo1146133vertigo
vervain1335563vervai_n
wearing113318863wearing
yerking15368813yerking
zeroing1738343zeroing

Search took 8 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.390458182.1
2DLD Change Limit1340272286.90619407.3
3Display Results2282280.0932451.6
 (SQL Overall)1786912287.38924183.4
 
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.