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

49 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
coinsurers124393(None) 
coinsurer1144771coinsurer_
coinsures1136721coinsure_s
censurers11256072c_ensurers
coinsure1046932coinsure__
coinsured1245512coinsure_d
conjurers18126232co_njurers
consumers1337202co_nsumers
insurers83710132__insurers
reinsurers1043572reinsurers
ceintures1136733ceinture_s
censurer10228133c_ensurer_
censures102211623c_ensure_s
coendures1245213coendure_s
coenures1048683coen_ure_s
coiffures1743213coiffure_s
coiners93620753coin___ers
coinfers13349503coin__fers
coinheres1447633coinhere_s
coinsuring1345373coinsuring
cointers103616413coin__ters
coistrels1145263coi_strels
colourers1136473co_lourers
conducers14136563co_nducers
confuters1437793co_nfuters
conjurer17117683co_njurer_
conjures17119913co_njure_s
conjurors18134503co_njurors
conquerers2144223co_nquerers
conquers1938223co_nqu_ers
conservers1547683co_nservers
considers1238933co_nsiders
consolers112510923co_nsolers
conspirers1444573co_nspirers
construers1245873co_nstruers
consulters1297213co_nsulters
consumer1238503co_nsumer_
consumes12310413co_nsume_s
ensurers8279373__ensurers
honourers1245573ho_nourers
injurers15286123__injurers
insureds9277613__insureds
insurer73312803__insurer_
insures73117263__insure_s
jointures16124873jointure_s
reinsurer945603reinsurer_
reinsures937963reinsure_s
tonsures869133to_nsure_s
uninsureds1151763uninsureds

Search took 7 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 Filter1786911406030.406440125.6
2DLD Change Limit140603496.28022389.0
3Display Results49490.0163062.5
 (SQL Overall)178691496.70226662.3
 
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.