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

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

48 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
coinsurances165301(None) 
coinsurance1553201coinsurance_
insurances1246862__insurances
reinsurances1452812reinsurances
coinsures1136723coinsur___es
consonances1545773co_nsonances
insurance1147453__insurance_
monstrances1545013mo_nstrances
noninsurance1462773noninsurance_
reinsurance1353143reinsurance_
assurances1244694__assurances
cofinances1745304cofin___ances
cognizances2552504cogn_izances
coincidences1683524coincidences
coinsure1046934coinsur___e_
coinsured1245514coinsur___ed
coinsurer1144774coinsur___er
coinsurers1243934coinsur__ers
coinsuring1345374coinsurin__g
concordances16103684co_ncordances
concurrences1554404co_ncurrences
conductances1653054co_nductances
conferences1898814co_nferences
conformances21104094co_nformances
congruences1655014co_ngruences
connivances1854184co_nnivances
consciences1447024co_nsciences
conservancies2054114co_nservancies
consonance1446184co_nsonance_
consonancies1653924co_nsonancies
constancies1546644co_ns_tancies
constringes1445044co_nstringes
consulates12711104co_nsula_tes
consultancies1782654co_nsultancies
consumables1753204co_nsumables
continuances1654684contin_u_ances
conversances1975724co_nversances
conveyances2185204co_nveyances
countenances1655734countenances
courantes1148884co___urantes
endurances1344934__endurances
hindrances1644844_hin_drances
instances1148754__ins_tances
insurants947654__insuran_ts
insurgences1454634__insurgences
issuances1144644__issu_ances
monstrance1445234mo_nstrance_
reassurances14112604reassurances

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 Filter1786911247900.390458182.1
2DLD Change Limit124790487.14017477.6
3Display Results48480.0331454.5
 (SQL Overall)178691487.56323627.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.