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

99 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
coinsure104693(None) 
coinsured1245511coinsured
coinsurer1144771coinsurer
coinsures1136721coinsures
ceinture1036312ceinture
censure92310602c_ensure
cocksure1645132cocksure
coendure1145462coendure
coenure968152coen_ure
coiffure1643122coiffure
coinhere1337132coinhere
coinsurers1243932coinsurers
conjure16109072co_njure
consume11510132co_nsume
insure63416602__insure
jointure15134832jointure
reinsure837912reinsure
tonsure758782to_nsure
ceintures1136733ceintures
censured11248913c_ensured
censurer10228133c_ensurer
censures102211623c_ensures
cincture1245583c_incture
cinque1736853c_inqu_e
closure9278483c_losure
coassume12103973coassume
coendured1344093coendured
coendures1245213coendures
coenures1048683coen_ures
coenuri945453coen_uri
coiffured1842613coiffured
coiffures1743213coiffures
coinable12311583coinable
coinage10310553coin_age
coincide1346493coincide
coiner84323783coin_er_
coiners93620753coin_ers
coinfer12419393coinfer_
coinfers13349503coinfers
coinhered1536593coinhered
coinheres1447633coinheres
coinmate1239063coinmate
coins75834553coins___
coinsurance1553203coinsurance
coinsuring1345373coinsuring
cointer93616723cointer_
cointers103616413cointers
coistrel1046743coi_strel
colure8314163co__lure
commissure1652723commissure
composure1545123composure
concur10411103co_ncur_
concurs11311473co_ncurs
conduce12139233co_nduce
confuse1238853co_nfuse
confute1239263co_nfute
conjured18117903co_njured
conjurer17117683co_njurer
conjures17119913co_njures
conquer1838623co_nquer
conserve1339933co_nserve
console92715983co_nsole
consort91319903co_nsort
conspire1257873co_nspire
construe1049053co_nstrue
consul82312303co_nsu_l
consuls92412313co_nsuls
consult92513633co_nsult
consumed1337923co_nsumed
consumer1238503co_nsumer
consumes12310413co_nsumes
contuse9311413co_ntuse
cornute939643corn_ute
couture9310623co_uture
cynosure1343553cynosure
ensure63416003__ensure
fissure1036783_fissure
injure133410863__injure
insured83714253__insured
insurer73312803__insurer
insures73117263__insures
inure54119053__in_ure
jointured17133483jointured
jointures16124873jointures
leisure736693lei_sure
moisture1046653moisture
noninsured1153273noninsured
reinjure1544983reinjure
reinsured1036983reinsured
reinsurer945603reinsurer
reinsures937963reinsures
rondure837313ro_ndure
scissure1043273scissure
seisure738193sei_sure
soilure736233soi_lure
tonsured976383to_nsured
tonsures869133to_nsures
uninsured1044873uninsured
unsure62815413__unsure

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.406440125.6
2DLD Change Limit146162997.39019778.3
3Display Results99990.0462152.2
 (SQL Overall)178691997.84222786.4
 
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.