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 “wisdom” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

142 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
wisdom123598(None) 
wisdoms1335451wisdoms
lissom837402lissom
misdo85413182misdo_
unwisdom1441812unwisdom
widow1278932wi_dow
wifedom1643552wifedom
window1347362window
besom95716973bes_om
bishop1336943bishop
bison75716983bis_on
bosom95516923bos_om
bossdom1244243bossdom
cisco95112133cisco_
ciscos104711133ciscos
condom114215363condom
custom104010273custom
diadem1037583diadem
diatom939453diatom
dido66528203di_do_
didos76820813di_dos
dildo71911773dildo_
dildoe8198673dildoe
dildos8179303dildos
dirdum1036033dirdum
disarm9310473disarm
disco85616073disco_
discos94915213discos
distome10313233distome
dogdom1186363dogdom
dom69752443___dom
eidos65817753ei_dos
fandom122110893fandom
fido87726403fi_do_
fidos95819053fi_dos
fiefdom1643013fiefdom
filmdom1562943filmdom
gismo848863gismo_
gismos957183gismos
heirdom1344493heirdom
idem76121063_i_dem
idiom899963_idiom
idol56818633_i_dol
indol63714873_indol
indow95011663_indow
ism56322383_is__m
jism135514773jis__m
kiddo11398953kiddo_
kiddos12416863kiddos
kingdom1543543kingdom
lido56028163li_do_
lidos65219883li_dos
lissome937583lissome
misaim10311853misaim
misdeem12217873misdeem
misdid10510573misdid
misdoer1048633misdoer
misdoes10312493misdoes
misdone10310863misdone
misform1437513misform
miso67229903mis_o_
misos76523293mis_os
pisco96314983pisco_
piscos105112593piscos
piso66727563pis_o_
pisos76021063pis_os
pistol83313333pistol
piston83515923piston
pistou83211843pistou
random92513553random
seldom939413seldom
simoom1037503simoom
sitcom1036903sitcom
sodom8814913_sodom
som59153813__s_om
unwisdoms1551303unwisdoms
vision9311313vision
visor82512833vis_or
weirdo10405883weirdo_
weirdos11355123weirdos
weldor10317653weldor
whilom1436133whilom
whom127018183w__hom
widder112913973widder
widdie113410733widdie
widdle113814843widdle
widdy136112183wi_ddy
wide85235413wi_d_e
widen94717973wi_den
wider94826353wi_der
wides94832823wi_des
widows1376563wi_dows
width12310963wi_dth
wifedoms1743463wifedoms
wigeon1037223wigeon
wigwam1544723wigwam
wilco1039443wilco_
wild85126513wild__
wilded113714503wilded
wilder103616473wilder
wildly13328123wildly
wilds94818203wild_s
willow12369693willow
wind85533853wind__
winded114918213winded
winder104025263winder
windle104617953windle
windows1447743windows
windowy1744643windowy
windrow1445853windrow
winds95425603wind_s
windup1235383windup
windy126118103wind_y
winnow1234593winnow
wino75933613wi_no_
winos84625043wi_nos
winsome1237463winsome
wis66552333wis___
wise75737343wis__e
wised95123343wis_ed
wisely122711713wisely
wisent93516343wisent
wiser85522803wis_er
wises85633193wis_es
wisest95016443wisest
wish107228733wis__h
wisha114910853wis_ha
wished134417513wished
wisher123617063wisher
wishes124920953wishes
wising103318223wising
wisp97124073wis__p
wisped123411893wisped
wisps105214183wis_ps
wispy137210973wis_py
wiss75630543wis__s
wissed104114643wissed
wisses94619603wisses
wist78049293wis__t
wisted104120273wisted
wists86728523wis_ts
wittol935923wittol

Search took 6 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 Filter1786911127160.373479064.3
2DLD Change Limit1127161424.75023729.7
3Display Results1421420.0463087.0
 (SQL Overall)1786911425.16934569.7
 
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.