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

54 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
resealable124618(None) 
repealable1445981repealable
resalable1138731res_alable
revealable1545081revealable
reelable10311592re_e_lable
releasable1245482releasable
repeatable1447602repeatable
resectable1478122resectable
reservable1546362reservable
resettable1256512resettable
sealable101512692__sealable
appealable1643853appealable
escapable1544983_escapable
healable131610173__healable
irrepealable1652923irrepealable
peelable1238553pe_e_lable
presentable1546033presentable
preservable1844163preservable
readable11313163r__eadable
reapable12311393r__eapable
recallable1445373recallable
receivable1745513receivable
recyclable1943643recyclable
redeemable1543953redeemable
reefable1339533re_e_fable
referable1439623refe_rable
refillable1544073refillable
regulable1246513re_gulable
relatable11310053re_latable
relaxable1836363re_laxable
relegable1258103rele_gable
remediable1545133remediable
renewable1447433rene_wable
reparable1359953re_parable
repayable1666343re_payable
rescuable1347583res_cuable
researchable1951863researchable
resemble1247313rese__mble
resoluble1144143res_oluble
resolvable1544583resolvable
respectable1755043respectable
respirable1446023respirable
restable101618443res__table
restartable1343543restartable
restorable1246753restorable
resumable1347553res_umable
reverable14310363reve_rable
salable91415463__s_alable
scalable121710233__scalable
sellable101711823__sellable
stealable1136573_stealable
unsalable1148993uns_alable
unscalable1446353unscalable
unsellable1247093unsellable

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.1561145455.1
2DLD Change Limit140603546.76620780.8
3Display Results54540.0163375.0
 (SQL Overall)178691546.93825755.4
 
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.