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

50 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
reinsurance135314(None) 
reinsurances1452811reinsurances
coinsurance1553202coinsurance
insurance1147452__insurance
reassurance13142762reassurance
coinsurances1653013coinsurances
endurance1245243_e_ndurance
insurances1246863__insurances
noninsurance1462773noninsurance
reassurances14112603reassurances
reentrance1245463reen_trance
reinsure837913reinsur___e
reinsuring1146383reinsurin_g
remonstrance1653403remonstrance
assurance1145294__assurance
censurable1445654ce_nsurable
endurances1344934_e_ndurances
entrance10311334_e_n_trance
hindrance1544474_hin_drance
instance1049884__ins_tance
insurable111011094__insurable
insurant8411434__insuran_t
insurants947654__insurants
insurgence1355014__insurgence
issuance1045224__issu_ance
mensurable1445454me_nsurable
monstrance1445234_monstrance
penetrance1444904pe_netrance
reentrances1345174reen_trances
refinance14117654refin___ance
reincarnate1352544reincarnate
reinduce1165434reindu___ce
reinforce1464484reinfor__ce
reinjure1544984reinjur___e
reinjuring1844424reinjurin_g
reinsman1045844reins_man__
reinstate948904reins_ta_te
reinsured1036984reinsur__ed
reinsurer945604reinsur__er
reinsurers1043574reinsur_ers
reinsures937964reinsur__es
remembrance19143074remembrance
remonstrances1752994remonstrances
renounce1047404re_nou__nce
resistance1245884resis_tance
resonance1147624re__sonance
resurface1443274re__surface
resurgence1345494re__surgence
securance1345874se__curance
uninsurable1384974uninsurable

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 Filter1786911488190.420425454.8
2DLD Change Limit148819508.95316622.2
3Display Results50500.0163125.0
 (SQL Overall)178691509.38919032.0
 
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.