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

253 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
recomb123887(None) 
recombs1336751recombs
become123312592become
comb106632112__comb
recoal84117972recoal
recoat84024272recoat
recock145112722recock
recode93618712recode
recoil84016722recoil
recoin84320292recoin
recombed1536712recombed
recon75624242reco_n
recons84922992recons
recook125513922recook
recopy1339042recopy
record96117422record
recork126315482recork
recoup10810372recoup
resorb84914342resorb
rhomb12399802r_homb
aplomb1236203aplomb
became123213163became
becomes132911963becomes
bedumb1335063bedumb
benumb1235773benumb
besom95716973besom_
besoms105712733besoms
bomb106927423__bomb
cecum11611843cecum_
celom9515683celom_
celoms10412123celoms
clomb115714703_clomb
cob710258753__co_b
cobb106421993__cobb
coma87134853__coma
combe116223543__combe
combo114519433__combo
combs116122963__combs
come87547703__come
comp106731253__comp
coomb115615703_coomb
coxcomb2243293coxcomb
decamp1338453decamp
deco76125973deco__
decoct11313783decoct
decode104414743decode
decor84717573deco_r
decors94017773decors
decos85522123deco_s
decoy115716313deco_y
decoys123911283decoys
demob104913503demo_b
desorb95210203desorb
entomb1037363entomb
enwomb1344973enwomb
firebomb1743413firebomb
genom83716843genom_
genome94312193genome
genoms94412483genoms
hecatomb1742973hecatomb
income10712093income
intomb1036403intomb
kebob135110913kebo_b
leucoma1144453leucoma
precode12311853precode
precook1577803precook
precool1139013precool
precoup1336123precoup
raceme1039733raceme
racon75422143raco_n
racons84319343racons
racoon83814473racoon
radome9511873radome
realm75621623realm_
realms84913493realms
ream65841613re_am_
reams75729623re_ams
rearm75923563rearm_
rearms85114653rearms
reb55844963re___b
rebody1238153rebody
reboil83814683reboil
rebook125213203rebook
reboot84119333reboot
rebop9313283rebo_p
rebops10311423rebops
rebore86625643rebore
reborn810016953reborn
rebozo1737323rebozo
rec55645463rec___
recall83815723recall
recane83022873recane
recant83228683recant
recap95718023rec_ap
recaps103615733recaps
recast83422773recast
recce9514563rec_ce
recces10614913recces
recede95515533recede
recent83630853recent
recept103319073recept
recess8314263recess
rechew14310213rechew
rechose121312043rechose
recipe103414893recipe
recit75235103rec_it
recite83625113recite
recits83621353recits
reck106130563rec__k
recked134821803recked
reckon123010543reckon
reckons13269653reckons
recks115625133rec_ks
reclad9311873reclad
reclame11411063reclame
recoals94214623recoals
recoats92616643recoats
recocks154711463recocks
recoded113115033recoded
recodes102918633recodes
recoils93814873recoils
recoins94019243recoins
recolor978693recolor
recombine1546103recombine
recombing1637323recombing
recommit1445553recommit
recooks134711233recooks
records105213923records
recorks134813023recorks
recount9315173recount
recoupe11109933recoupe
recoups1188843recoups
recover124312623recover
recross989833recross
recrown12257573recrown
recs65734183rec__s
recta74220263rec_ta
rectal84418133rectal
recti73619623rec_ti
recto74520803rec_to
rector84019743rector
rectors93520513rectors
rectory123512723rectory
rectos85718783rectos
rectum103411283rectum
rectums11338523rectums
rectus83314633rectus
recur74116843rec_ur
recurs83315803recurs
recuse85519163recuse
recut74729243rec_ut
recuts83817373recuts
redcoat10410883redcoat
redo56029363redo__
redock134311543redock
redoes74623753redoes
redon65424883redo_n
redone74820053redone
redons75222183redons
redos65126763redo_s
redoubt10167843redoubt
redout71820253redout
redowa1038453redowa
redox134714233redo_x
redub84212413re_dub
refold103812113refold
reform11312703reform
reforms1239813reforms
regime95313943regime
regma84612333re_gma
rehab10312443re_hab
rehem103815353rehem_
rehems113410983rehems
rejoin134012243rejoin
reload7413893reload
reloan6415693reloan
relock124713523relock
relook104813743relook
relume8313273relume
rem56150043re__m_
remold93412973remold
remora8414583remora
remote84222603remote
remove116115573remove
rems66237723re__ms
rename82718813rename
renown9369983renown
reoil55321183re_oil
replumb1343393replumb
repo66027543repo__
repoll8410793repoll
report85326013report
repos74725793repo_s
repose84121413repose
repot75132623repo_t
repots85621003repots
repour8310993repour
repump1235683repump
reroll6412683reroll
reroof9315003reroof
rerose63320843rerose
rescore95616193rescore
resoak10311093resoak
resod64720053reso_d
resods74116303resods
resold73915363resold
resole64624183resole
resorbs95010523resorbs
resort65728613resort
resow88217243reso_w
resown94112923resown
resows93915353resows
resume8313783resume
retem74221953retem_
retems83914573retems
retime85321803retime
retold73013753retold
retook104313443retook
retool63914483retool
retore67630763retore
retorn610923423retorn
retort66831143retort
revamp1336013revamp
reverb113912573reverb
revoke135216243revoke
revolt9316223revolt
revote94917453revote
rewoke1339521213rewoke
rewon86920573rewo_n
reword106321403reword
rewore938030153rewore
rework136619783rework
reworn98122193reworn
rewove126420073rewove
rezone153814783rezone
rhombi13365193r_hombi
rhombs13336493r_hombs
rhumb12438653r_humb
rob56754303r__o_b
rococo1036813rococo
rom59855633r__om_
romp85926573r__omp
roms67038963r__oms
room66235083r_oom_
rooms75324683r_ooms
roomy107118063r_oomy
second9411153second
telome8311923telome
tomb89029653__tomb
venom103914863venom_
venoms114211213venoms
welcome1445193welcome
womb117022233__womb

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 Filter1786911127160.1431249587.4
2DLD Change Limit1127162537.42315184.7
3Display Results2532530.1701488.2
 (SQL Overall)1786912537.73623098.6
 
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.