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

190 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
onrush93534(None) 
inrush936511inrush
ankush13114432ankush
brush105917472_brush
crush106815992_crush
ogrish1039262ogrish
onrushes1135212onrushes
onus45826812on_us_
outrush1037042outrush
qurush1835502qurush
rush76628182__rush
thrush12257482thrush
uprush1135782uprush
ablush1147223ablush
afresh1255503afresh
ambush1336103ambush
anguish11117633anguish
ankus91410683ankus_
anus47131113an_us_
blush105115313_blush
boarish123911913boarish
bonus75324323bon_us_
boorish123712593boorish
brash106221563_brash
brugh115414293_brugh
brushy14468263_brushy
brusk114912433_brusk
bulrush1243593bulrush
bush96630713__bush
ceruse83914523ceruse
choush14549063choush
concuss1138063concuss
confuse1238853confuse
contuse9311413contuse
conus76726533con_us_
cornus84816563cornus_
crash109120013_crash
crus65828483_crus_
cruse75726103_cruse
crust75827663_crust
donnish11187633donnish
druse64817663_druse
ecrus75113863ecrus_
encash11276943encash
encrust947873encrust
endash10297123endash
enmesh1134893enmesh
enough1045753enough
enrich1138943enrich
entrust7410883entrust
flush115116073_flush
fondus105210943fondus_
fresh115012203_fresh
frosh115713403_frosh
garish104516923garish
girsh95310023gir_sh
gnash9449833gn_ash
gnus56518003gn_us_
gursh94512333gur_sh
gurus64318193gurus_
gush85424003__gush
gyrus95310803gyrus_
harsh116418053har_sh
hush105224113__hush
incrust949203incrust
incus73315053incus_
incuse83513573incuse
infuse93110573infuse
inmesh1134853inmesh
inrun52911373inru_n
inruns6359513inruns
inrushes1136273inrushes
intrust7311493intrust
knish1238603kn_ish
knurs94511153knurs_
kurus98015633kurus_
longish11229093longish
lush75327693__lush
marish114319053marish
marsh105320853mar_sh
monish114217593mon_ish
monkish1638243monkish
moorish123311783moorish
mush94929123__mush
nodus66315993nodus_
noirish1037883noirish
noncash1245163noncash
nonsuch1244683nonsuch
nontruth1144453nontruth
nonuse63212253nonuse
noris54928273noris_
norms76019303norms_
north86018273nor_th
norths96812323norths
nosh76223543_n_osh
nourish1039703nourish
nous46136983_nous_
nurse54420123_nurse
nus37939393_n_us_
oafish121311723oafish
oarfish13158613oarfish
oars46846033oar_s_
obtuse8147483obtuse
oddish11107653oddish
offish15137273offish
ogreish1134673ogreish
ogres65818633ogres_
ogress7529503ogress
ogrism937913ogrism
okras94410973okras_
oldish10169313oldish
onerous7312963onerous_
ones46146533on_es_
onium73115533oniu_m
onos46229003on_os_
onrushing1364813onrushing
ons36148513on__s_
onuses65616253on_uses
opus66420593o_pus_
orach105219233o_rach
orbs66626253o_rbs_
orcs67025433o_rcs_
ores46056683o_res_
orisha936773o_risha
ornis54616773ornis_
orris54516553orris_
ors35750113o_r_s_
orts46538333o_rts_
ouch95724633o__uch
ouph95618373o__uph
ours47237563our_s_
oust46747443o__ust
outgush1145133outgush
outpush1245493outpush
overlush1445273overlush
overuse10310923overuse
owlish1238693owlish
parish115022353parish
perish114619063perish
peruse84016843peruse
plush105614713_plush
poorish123712303poorish
push95526623__push
qursh174110843qur_sh
rash76039933__rash
resh76523453__resh
ruse45938933__ruse
rushy115414813__rushy
rusk85823313__rusk
rust45544913__rust
ruth76825993__ruth
shush113812543_shush
slush85316573_slush
smush104410583_smush
snash84815673sn_ash
sneesh945893sneesh
sorus54527583sorus_
sourish10310693sourish
squush1833993squush
tarbush1234173tarbush
thrash12258353thrash
thresh12276863thresh
thrust91911893thrust
tonish93415903ton_ish
tonnish10149093tonnish
tonus56324303ton_us_
torus54329763torus_
trash86119763_trash
truss54916923_truss
trust55426853_trust
truth85214153_truth
tush74523903__tush
unaus53216573unaus_
unbusy1135213unbusy
uncus74014983uncus_
unhusk1334263unhusk
unjust1337873unjust
unlash938793unlash
unmesh1145793unmesh
unrest62918853unrest
unrough11105233unrough
unruly938083unruly
unrushed12247573unrushed
untruss736553untruss
untruth1045353untruth
unwish1239093unwish
urus46426133_urus_
varus85921183varus_
virus85316843virus_
xerus12313333xerus_

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127161907.94014196.0
3Display Results1901900.0603166.7
 (SQL Overall)1786911908.14021952.2
 
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.