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

100 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
depainting1415615(None) 
bepainting15144881bepainting
repainting13128971repainting
decanting132510632deca_nting
departing1349512depa_rting
depicting1537812dep_icting
detaining112510472detain_ing
impainting1544502impainting
painting113614422__painting
reprinting131510582reprinting
appointing1545323appointing
attainting1144783attainting
daunting103310403d__aunting
deairing10311893de_ai_ring
deaminating1547973deaminating
deaning94020473de_a_n_ing
debating123213733deba__ting
debiting122511203de_bi_ting
declining13129353declin_ing
defanging1535333defa_nging
defatting1436103defa_tting
defaulting1543393defaulting
defining133711803de_fin_ing
delaminating1645683delaminating
delating103119603dela__ting
delisting112710503de_listing
demanding14237923dema_nding
demasting1338453dema_sting
dementing13311043de_menting
demitting13239073de_mitting
demounting1444963demounting
denting94422183de___nting
depaint10314593depaint___
depainted1375843depaint_ed
depaints1136643depaint__s
depending14208783dep_ending
depilating1439183depilating
deplaning1338053deplan_ing
depleting1378193dep_leting
deponing121211213dep_on_ing
deporting1369593dep_orting
depositing1446933depositing
depriving1636403depri_ving
depurating1438643depurating
deputing12238793dep__uting
deracinating1645223deracinating
deraigning1344103deraigning
derailing112011313derai_ling
deranging1238063dera_nging
derating103222283dera__ting
deratting1139513dera_tting
desalinating1476313desalinating
desalting1138843desa_lting
desanding12207653desa_nding
descanting1446923descanting
desisting112810383de_sisting
despairing1445063despai_ring
despiting13179323despi_ting
destaining1267943destain_ing
destining11311433destin_ing
detailing112510413detai_ling
detraining1267673detrain_ing
deveining1436393devein_ing
deviating14311083de_viating
dezincing2244183de_zincing
dinting93520553d___inting
draining103312673d_rain_ing
fainting123312163__fainting
feinting123410833fe__inting
imprinting1546023imprinting
levanting1345523leva_nting
mispainting1645293mispainting
outpainting1445153outpainting
paining103920243__pain_ing
paintings12327093__paintings
panting104025423__pa_nting
pepsinating1645373pepsinating
pointing112813683__pointing
preprinting1647413preprinting
printing113216083__printing
rebaiting12311643rebai_ting
recanting122414823reca_nting
regaining112411083regain_ing
remaining122212793remain_ing
reminting122315103re_minting
repairing12310013repai_ring
repasting122312843repa_sting
repenting122316553rep_enting
repining114116593rep_in_ing
repinning12258973rep_inning
replanting1338523replanting
retaining102114733retain_ing
retinting102215253re_tinting
sainting93215733__sainting
separating1348643separating
splinting1238193_splinting
sprinting12310033_sprinting
tainting93613583__tainting
tenanting1036213tena_nting
underpainting1763553underpainting

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 Limit1406031006.04623255.5
3Display Results1001000.0462173.9
 (SQL Overall)1786911006.49827499.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.