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

231 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
arbours9391003(None) 
arbors84717871arbo_rs
arbour84211321arbour_
ardours8368871ardours
armours9389841armours
harbours1346901harbours
amours83512642a_mours
arbor74818112arbo_r_
arbores94016032arbores
arboured1156252arboured
ardors74416862ardo_rs
ardour74110892ardour_
armors85017812armo_rs
armour84411852armour_
armoury12376232armoury
harbors12412412harbo_rs
harbour1247052harbour_
labours9349882labours
parlours1036152parlours
tabours94110072tabours
tambours1255862tambours
abbots1039283abbo_ts
abhors11410623a_bhors
abjure1536733a_bjure
abjures1636513a_bjures
aboard9312613a_board
abodes94417513a_bodes
abohms1335003a_bohms
abomas101113583a_bomas
abort76133583a_bo_rt
aborts84916183a_borts
abos67734413a_bo__s
abound9239863a_bound
abounds10217083a_bounds
about75229083a_bou_t
aboves114512843a_boves
absurd935903a_bsurd
absurds1035003a_bsurds
abuts75417073a_b_uts
actors81016753acto_rs
adjourn1563423adjourn
adjourns1662853adjourns
adnouns835453adnouns
airboats1047283airboats
airbound1144123airbound
airburst1044233airb_urst
airbus848343airb_u_s
albums10198273alb_ums
algors7312553algo_rs
ambeers11428923ambeers
ambers104519573amb_ers
amblers115213563amblers
ambones11312683ambones
ambos95321253ambo__s
amour75014853a_mour_
arbiters1038853arbiters
arbored103811603arbored
arborist10411613arborist
arborous1047713arborous
arbovirus1442973arbovirus
arbs66834733arb___s
arbute8311043arb_ute
arbutes939703arbutes
arbutus944843arbutus
archers124414573archers
arcus76918863ar_cu_s
ardor64617863ardo_r_
arduous837603arduous
arenous7314183arenou_s
areolas71013863areolas
areoles71016953areoles
argols74514613argo_ls
argons75018203argo_ns
argots74116023argo_ts
arguers8489023arguers
argues74516413ar_gues
argus66716543ar_gu_s
ariosos7409853ariosos
arkoses113910833arkoses
armers85520273ar_mers
armfuls1275013armfuls
armoire938133armoire
armoires1057623armoires
armor75118053armo_r_
armorers10288963armorers
armory114211473armo_ry
armoured1165223armoured
armourer1054883armourer
armourers1154063armourers
armouries1146233armouries
armure8710133ar_mure
armures9510273ar_mures
aroids75118223ar_oids
aromas81018613ar_omas
around72712413ar_ound
arouse65019983ar_ouse
arousers84810973ar_ousers
arouses74921293ar_ouses
arrears738843arrears
arrobas969213arrobas
arrows92813483arro_ws
arroyos1036533arroyos
arsons63917213arso_ns
arums75517833ar__ums
arvos86015663arvo__s
auburn836213aub_urn
auburns935573aub_urns
augurs7399963a_ugurs
aurous64119263aurou_s
auteurs7137503auteurs
awmous1157713awmou_s
barbers114317503barb_ers
barbuts11439843barb_uts
blurs74619083__blurs
boars75229603__boars
boors74325013__boors
bourg84113843__bourg
bourgs9459993__bourgs
bourn75518483__bourn
bourns84114063__bourns
bourse84414333__bourse
bouts75131313__bouts
burs65847423__b_urs
candours11408613candours
carbons115418943carbo_ns
carbora11310703carbo_ra
carboras12311573carboras
carbos105122263carbo__s
carboys144711783carbo_ys
caribous1258823caribou_s
carious93320283cariou_s
clours85215083_clours
colours95913413colours
croups104312553cr_oups
cruors838623cruo_rs
darbars10510093darb_ars
detours858033detours
devours1166643devours
dolours8438813dolours
drouks1137123dr_ouks
dyvours1453183dyvours
earbuds1044633earb_uds
erbiums1135463erbiums
errors63311313erro_rs
faitours1134253faitours
farceurs13464723farceurs
faubourg1461683faubourg
faubourgs1541223faubourgs
favours13437083favours
fervours1453053fervours
flours94414053_flours
fours85521493__fours
garblers113810283garblers
garboard1247243garboard
garboards1346363garboards
garboils1145663garboils
giaours834563giaours
groups94210513gr_oups
grouts75015613gr_outs
harbor11410723harbo_r_
harborers1446913harborers
harboured1544313harboured
haviours1443833haviours
honours10339353honours
hours85422383__hours
humours1286413humours
inpours936413inpours
labors84016403labo_rs
labour84210933labour_
larboard1157663larboard
larboards1246983larboards
lours55125293__lours
marabous1249063marabou_s
marabouts1364963marabouts
marblers12319233marblers
odours7418233_odours
ours47237563___ours
pandours11317983pandours
paramours1345643paramours
parboils1237433parboils
parlors9312913parlo_rs
parlour937263parlour_
parlous9414293parlou_s
parous84024163par_ou_s
paviours1343613paviours
pours74623183__pours
priors83914483prio_rs
probers113514573probers
ragouts838533ragouts
ramous8417103ramou_s
rancours1076703rancours
razors154711653razo_rs
recurs83315803_recurs
repours9310223repours
rigours8206993rigours
roars55622233_r_oars
roues56039353_r_oues
roups75118903_r_oups
routs57133413_r_outs
rubouts937973rubouts
rumours976363rumours
sambhurs1543183sambhurs
samburs11369343samb_urs
santours837173santours
sapours93610613sapours
sarcous9312933sarcou_s
sartors7314953sarto_rs
saviours1154273saviours
savours10389333savours
scours84913583_scours
sours55230503__sours
stours65015623_stours
tabors84517093tabo_rs
tabour84011313tabour_
tambour1136343tambour_
tamboura1253883tamboura
tambouras1343473tambouras
tamburs11288603tamb_urs
tenours72610053tenours
tours55325863__tours
trouts66116623tr_outs
tryouts1035293tryouts
tumours976733tumours
valours10248733valours
vapours12277453vapours
various103113103variou_s
velours10278083velours
vigours11285483vigours
vrouws12494743vr_ouws
warblers13319103warblers
yours85217873__yours

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.1561145455.1
2DLD Change Limit1340272317.17018692.7
3Display Results2312310.0802887.5
 (SQL Overall)1786912317.40624127.9
 
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.