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

109 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
corsair93763(None) 
corsairs1046861corsairs
cochair1446312cochair
corsac10410172corsa_c
corsacs1139012corsacs
corsage1039802corsage
bonsai838463bonsai_
bursar85413253bursa_r
caesar8410933caesa_r
certain92612213certain
chair105519633c__hair
cirsoid1038123cirsoid
coarser93211193coars_er
coaster94219033coaster
cocain101315013co_cain
cochairs1545893cochairs
coheir1137583co_heir
coir66327243co___ir
collar83816173colla_r
conspire1257873conspire
contain9315823contain
coral76033453cor_a_l
corals85325143cor_als
corban10314693corba_n
corbans11313173corbans
corbeil11859213corbeil
corbie103618203cor_bie
cordage11310063cordage
cordate10315213cordate
corder94322873cor_der
cordial10312933cordial
cordwain1444403cordwain
coremia11310363coremia
corer75538873cor__er
corgi8316083cor_gi_
corgis9314403cor_gis
coria75828303cor__ia
corkage1438373corkage
corker124720853cor_ker
corkier133114303corkier
cormoid12310403cormoid
corner84625623cor_ner
cornier93017083cornier
coroner94218203coroner
corrade101111043corrade
corral83616253corra_l
corrals93713853corrals
corrie83621213cor_rie
cors66656443cors___
corsages11310363corsages
corse75036183cors__e
corses84433463cors_es
corset85636223cors_et
corsetry1365563corsetry
corsets94819803corsets
corslet9318063corslet
cortin82423143cor_tin
coruler9311713coruler
corvid12310473cor_vid
cosher114819903co_sher
cosie74728263co_s_ie
cosier84423753co_sier
cosmic12410343co_smic
cosmid11810643co_smid
cossack1545823cossack
costar85518613co_star
coster84331293co_ster
cottar84613813cotta_r
cougar958783couga_r
couloir936143couloir
courser94114803cours_er
cousin8517153cous_in
cowskin1645553cowskin
cowslip1444013cowslip
coxswain2042393coxswain
crasis85020473c_rasis
crosier94116573crosier
crosser95015463crosser
crosshair1443133crosshair
curari84414403cur_ari
curser84721473curs_er
cursor84110293curs_or
curtail9299663curtail
curtain9319793curtain
dorsa64617283dorsa__
dorsad8408973dorsa_d
dorsal74613943dorsa_l
dorsals84110843dorsals
dorser74819173dors_er
foresaid1247803foresaid
foresail1147823foresail
forsake1436533forsake
forsaker1545103forsaker
gorsier83811073gorsier
horsehair1593653horsehair
horsier103013243horsier
korai97018513kor_ai_
mohair1135203mo_hair
mortar83812043morta_r
mosaic10311143mo_saic
ordain7810403_ordain
osar46820953_o_sa_r
prosaic11311163prosaic
sarsar63011843sarsa_r
topsail976523topsail
torsade837593torsade
torsi57423363tors_i_
worser95117523wors_er
worship1547833worship

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271098.09316560.9
3Display Results1091090.0462369.6
 (SQL Overall)1786911098.29521542.0
 
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.