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

145 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
corpora113935(None) 
corporal1248511corporal
carbora11310702carbora
carport11316032carport
comport133616842comport
coppra12306832co_ppra
copra98115462co_p_ra
cordoba1255742cordoba
corona83817402cor_ona
corporals1347272corporals
corporate13410902corporate
corporeal1344982corporeal
torpor839192torpor_
torpors939382torpors
airport9511383airport
aurora6411763aur_ora
caporal11410943c_aporal
carboras12311583carboras
carioca1139683carioca
carper104923633carper_
carpers114521253carpers
carpool1139223carpool
carports1238943carports
cerebra1155923cerebra
chroma132912473chr_oma
cobra95214403co__bra
cocoa98517883co_co_a
cohort1110720263co_hort
color76123743co_lor_
colors86622373co_lors
comfort143611693comfort
compare135814993compare
compart134016003compart
compere134616623compere
compo115318573compo__
compone136517193compone
compony1613011913compony
comports143411983comports
compos124818803compo_s
compose135716663compose
compost134515353compost
compote135616463compote
concord12510343concord
condor94616973condor_
condors104018573condors
conform14310463conform
consort91319903consort
contort91422343contort
contra83314703co_ntra
cooper104221123cooper_
coopers114019483coopers
coopery143910273coopery
coper95336093co_per_
copers104629843co_pers
copout10418783co_pout
copper124321893copper_
copperah17304903copperah
copperas14308573copperas
coppers133519753coppers
coppery16409393coppery
coppras13327833co_ppras
coprah133710603co_p_rah
copras103517153co_p_ras
copula102812043co_pula
corbina111911453corbina
corder94322883corder_
corders104520883corders
cordobas1345803cordobas
cordon95017293cordo_n
cordons104415763cordons
cordovan1444293cordovan
coremia11310363coremia
corer75538873cor_er_
corers85231073cor_ers
coria75828323cor__ia
corker124720853corker_
corkers134118853corkers
cormoid12310403cormoid
cormorant1348573cormorant
cormous11312353cormous
cornea84018933cor_nea
corner84625623corner_
corners94723313corners
cornpone1246933cornpone
cornrow1245603cornrow
cornua85411903cor_nua
corody12149703cor_ody
corolla938623corolla
coronae94214893cor_onae
coronal94115763cor_onal
coronas93916913cor_onas
corporally1775293corporally
corporates14410733corporates
corporator1446943corporator
corposant1347093corposant
corps95927043corp__s
corpse104013403corp_se
corpses113913803corpses
corpsman1445133corpsman
corpus106015293corp_us
corral83616253cor__ral
corrida1078513corrida
corrode101310573corrode
corrody13136143corrody
cortina91915973cortina
corvina12229503corvina
coryza2074583cor_yza
coupon102810993coupo_n
coupons112710563coupons
cowpea1337643cowp_ea
cowpoke1835103cowpoke
cowpox2035003cowpo_x
coypou13268403coypo_u
coypous14248813coypous
crapola1136913crapola
crore74922873c_r_ore
cruor7310453c_ruor_
cruors838643c_ruors
crura7312583c_r_ura
cupola10317693c_upola
curara83712203cur_ara
curiosa9346643curiosa
cursor84110293cursor_
cursors93910023cursors
cursory12406393cursory
dorper94314573dorper_
dorpers104113173dorpers
forbore12249673forbore
forlorn1096423forlorn
forworn13107793forworn
gosport101010283gosport
horror988723horror_
horrors1078693horrors
lordoma1056043lordoma
morphia1447483morphia
oospore939013oospore
opera7313573_o_pera
orra46120723_or__ra
purport1159393purport
purpura1144793purpura
sopor74016493so_por_
sopors85215203so_pors
sordor7310223sordor_
sordors8310013sordors
sororal7310653sor_oral

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.403443402.0
2DLD Change Limit1340271457.48617903.7
3Display Results1451450.0632301.6
 (SQL Overall)1786911457.95222471.2
 
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.