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

89 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
coinsured124551(None) 
coinsure1046931coinsure_
coinsurer1144771coinsurer
coinsures1136721coinsures
censured11248912c_ensured
coendured1344092coendured
coiffured1842612coiffured
coinhered1536592coinhered
coinsurers1243932coinsurers
conjured18117902co_njured
consumed1337922co_nsumed
insured83714252__insured
jointured17133482jointured
noninsured1153272noninsured
reinsured1036982reinsured
tonsured976382to_nsured
uninsured1044872uninsured
ceinture1036313ceinture_
ceintures1136733ceintures
censored11197953c_ensored
censure92310603c_ensure_
censurer10228133c_ensurer
censures102211623c_ensures
censused11184973c_ensused
cinctured1444273c_inctured
cindered1239793c_indered
clinkered1634773clinkered
closured11266353c_losured
coassumed14112933coassumed
cocksure1645133cocksure_
coendure1145463coendure_
coendures1245213coendures
coenure968153coen_ure_
coenures1048683coen_ures
coiffure1643123coiffure_
coiffures1743213coiffures
coincided1544023coincided
coined94523603coin___ed
coinferred1643893coinferred
coinhere1337133coinhere_
coinheres1447633coinheres
coinsuring1345373coinsuring
cointerred1346553cointerred
coistrel1046743coi_strel
coloured1148313co_loured
concurred1445673co_ncurred
conduced14136963co_nduced
confused1437033co_nfused
confuted1437683co_nfuted
conjure16109073co_njure_
conjurer17117683co_njurer
conjures17119913co_njures
conquered2145463co_nquered
conserved1538843co_nserved
consoled112911443co_nsoled
consorted1239773co_nsorted
conspired1445663co_nspired
construed1247303co_nstrued
consulted1277923co_nsulted
consume11510133co_nsume_
consumer1238503co_nsumer
consumes12310413co_nsumes
contoured1237303contoured
contused1138443co_ntused
cornered11311133corn_ered
cornuted1137473corn_uted
counseled1245053counseled
countered12313003countered
ensured83512943__ensured
fissured1235183_fissured
honoured1236313ho_noured
injured15339063__injured
insure63416603__insure_
insureds9277613__insureds
insurer73312803__insurer
insures73117263__insures
inured73114813__in_ured
jointure15134833jointure_
jointures16124873jointures
leisured934763lei_sured
reinjured1744533reinjured
reinsure837913reinsure_
reinsurer945603reinsurer
reinsures937963reinsures
tonsure758783to_nsure_
tonsures869133to_nsures
unensured1044943unensured
uninjured1743353uninjured
uninsureds1151763uninsureds

Search took 10 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 Filter1786911486410.1701051123.5
2DLD Change Limit148641898.83016833.6
3Display Results89890.0761171.1
 (SQL Overall)178691899.07619688.3
 
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.