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

37 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
irresolvable175283(None) 
irremovable1853502irremo_vable
irresoluble1362152irresol_uble
resolvable1544582__resolvable
unresolvable1753562unresolvable
insolvable1545363i__nsolvable
irreformable1962983irreformable
irremovably2153283irremo_vably
irrevocable1853393irrevo_cable
revolvable1843513__revolvable
dissolvable1753144_dissolvable
evolvable1743384___evolvable
insolvably1854164i__nsolvably
irrecoverable2062184irrecoverable
irrecusable1554054irre_cusable
irredeemable17152374irredeemable
irrefragable18132584irrefragable
irrefutable1653984irre_futable
irremeable1444704irre__meable
irremediable1752494irremediable
irreparable1584434irre_parable
irrepealable1652924irrepealable
irresistible1462564irresistible
irresolute1051494irresol__ute
irresolutely1561294irresolutely
irresponsible1762274irresponsible
irretrievable1871824irretrievable
irrevocably2153164irrevo_cably
isolable1038794i___sol_able
preservable1844174_preservable
removable1646924__remo_vable
resalable1138734__resal_able
reservable1546374__reservable
resoluble1144144__resol_uble
solvable1337474____solvable
unremovable1854564unremo_vable
unsolvable1545084__unsolvable

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 Filter1786911247900.376475242.0
2DLD Change Limit124790376.46619299.4
3Display Results37370.0162312.5
 (SQL Overall)178691376.85826055.8
 
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.