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

78 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
mindful134461(None) 
aidful1057072ai_dful
handful14127252handful
manful11610212man_ful
mindfully1843462mindfully
remindful1551882remindful
sinful938802sin_ful
tinful938042tin_ful
unmindful1551852unmindful
aimful1166703ai_mful
baneful1237893baneful
canful11610263can_ful
cansful1236833cansful
direful1156613direful
dishful1455433dishful
fistful1365903fistful
fitful1256333fi_tful
gainful1145833gain_ful
handfuls15115753handfuls
handsful1544083handsful
headful1445563headful
heedful1444313heedful
hindgut1245013hindgut
indium939503_indium
indol63714873_ind_ol
indue63516673_ind_ue
indult73614033_ind_ult
inhaul936803_inhaul
insoul638463_insoul
ireful948713_ireful
kistful1465303kistful
lifeful1344613lifeful
lungful1144013lungful
mandrel1038683mandrel
mandril1049353mandril
menseful1344043menseful
miaul71612123mi__aul
midcult1246303mi_dcult
midgut103510053mi_dgut
mind75434393mind___
minded103817833mind_ed
minder94822503mind_er
minders103720123minders
minding113317893minding
minds85427133mind__s
mindset10313343mindset
mineral9312743mineral
minibus1136343minibus
minify1439253minif_y
minimal114010603minimal
minimum10456143minimum
minium106014423min_ium
minus75223933min__us
mirthful1642863mirthful
misdeal1037663misdeal
misdial1039643misdial
moanful12105003moanful
moistful1343853moistful
monofil1247273monofil
monofuel1344053monofuel
mugful1235403m_ugful
museful1245893museful
needful1143863needful
painful1246413pain_ful
panful1179743pan_ful
pipeful1445643pipeful
pitiful1245863pitiful
skinful1444193skin_ful
songful1145173songful
tankful1445163tankful
tinfuls1036593tin_fuls
tuneful1046123tuneful
wilful1235963wi_lful
willful1344533willful
windfall1544203windfall
windup1235383wind_up
wishful1664503wishful
wistful1365713wistful

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 Filter1786911340270.406440125.6
2DLD Change Limit134027786.40620922.1
3Display Results78780.0332363.6
 (SQL Overall)178691786.84526105.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.