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 “corsairs” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

81 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
corsairs104687(None) 
corsair937631corsair_
cochairs1545902cochairs
corsacs1139012corsa_cs
corsages11310362corsages
bursars94510893bursa_rs
caesars9410733caesa_rs
chairs114916183c__hairs
coasters104317333coasters
cocains111313923co_cains
cochair1446313cochair_
coheirs1236753co_heirs
coirs75221053co___irs
collars93816573colla_rs
conspire1257873conspire
conspires1358483conspires
contains10316533contains
corals85325143cor_a_ls
corbans11313173corba_ns
corbeils12358073corbeils
corbies113520123cor_bies
cordages12310113cordages
corders104520883cor_ders
cordials1139633cordials
cordwains1544153cordwains
corers85231073cor__ers
corgis9314413cor_gi_s
corkages1539103corkages
corkers134118853cor_kers
corners94723313cor_ners
corodies11313693corodies
coroners104016223coroners
corrades111211263corrades
corrals93713853corra_ls
corries94026803cor_ries
corsac10410173corsa__c
corsage1039803corsa_ge
corses84433463cors__es
corsetry1365573corsetry
corsets94819803cors_ets
corslets1038273corslets
cortins92421333cor_tins
corulers1039773corulers
corvids1337683cor_vids
coshers123618183co_shers
cosies84932153co_s_ies
cosmids1237633co_smids
cossacks1645223cossacks
costars94218013co_stars
costers94128333co_sters
cottars94412243cotta_rs
cougars1038443couga_rs
couloirs1045993couloirs
coursers104412303cours_ers
cousins9516003cous_ins
cowskins1745263cowskins
cowslips1543613cowslips
coxswains2142463coxswains
crasis85020473c_rasi_s
crosiers103312063crosiers
crossers103912703crossers
crosshairs1552793crosshairs
curaris94114773cur_aris
cursers94317163curs_ers
cursors93910023curs_ors
curtails10318243curtails
curtains10259703curtains
dorsals84110853dorsa_ls
dorsers83516303dors_ers
foresails1247153foresails
forsakers1644653forsakers
forsakes1536893forsakes
horsehairs1683693horsehairs
mohairs1234953mo_hairs
mortars93411523morta_rs
mosaics1138073mo_saics
ordains879653_ordains
sarsars73512143sarsa_rs
topsails1075093topsails
torsades937213torsades
worships1647103worships

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 Filter1786911461620.423422437.4
2DLD Change Limit146162817.45319611.2
3Display Results81810.0302700.0
 (SQL Overall)178691817.90622601.9
 
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.