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

107 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
equably213618(None) 
equable1849251equable
equally1936871equally
equal1449822equa_l_
equals1538692equa_ls
equitably2344422equitably
squabby2343282squabby
squally1937672squally
squatly1946432squatly
suably112814532_suably
ably99725133___ably
affably1855183affably
amiably1438303amiably
arguably1444503arguably
bearably15177933bearably
bubbly124110353_bubbly
burbly134311153_burbly
capably1639253capably
coequally2344043coequally
crumbly16347523crumbly
curably142010773curably
deniably1448553deniably
doubly12328963dou_bly
drably123511613_drably
dually103210063_dually
dumbly14399603_dumbly
durably13229053durably
early85324123e__arly
eatable91717603eatable
educable1337093educable
effable15106673effable
enable83318483e_nable
endurably1545673endurably
enviably1645353enviably
equability2446743equability
equaled17166923equaled
equality2046993equality
equalled1834863equalled
equatable2045193equatable
equate152012463equa_te
equated171910403equated
equates162012323equates
equator1637483equator
equerry1943053equerry
equinely2044643equinely
equitable2046193equitable
equity1838103equ_ity
errable9312183errable
excusably2343213excusably
eyeable1239063eyeable
grumbly15355403grumbly
hubbly16478413_hubbly
humbly164010523_humbly
issuably1344963issuably
laudably1445123laudably
lovably15187063lovably
movably17167043movably
mumbly15319463_mumbly
mutably1438613mutably
notably12199993notably
nubbly13369673_nubbly
numbly134410663_numbly
payably17177093payably
pliably14147383pliably
quacky24376963_quacky
quaggy2084683_quaggy
quail144314363_quail_
quails153412643_quails
quakily2336693_quakily
quaky214310743_qua_ky
quale143617853_qua_le
qualm163511183_qua_lm
qualmy20285803_qualmy
quarry1837473_quarry
quay164618353_qua__y
quotably2244153_quotably
ratably121711513ratably
readably1438383readably
refutably1785333refutably
reliably1339243reliably
reputably1686453reputably
rubbly133710613_rubbly
rumbly134412163_rumbly
salably121610743salably
sexually1845603sexually
sizably2136613sizably
squab163810733squab__
squabble2143883squabble
squabs17429323squab_s
squall1538003squa_ll
squalls1647313squalls
squarely2045353squarely
squashy2233843squashy
squatty1964823squatty
stably113314123_stably
stubbly1444473stubbly
suable83920553_suable
taxably1936043taxably
tenably122210453tenably
tunably12218293tunably
unequally2144193unequally
usably11288983_usably
useably1287393useably
usually1066063usually
valuably1644713valuably
viably14199833_viably
vocably17157153vocably

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 Limit1340271076.45320769.7
3Display Results1071070.0462326.1
 (SQL Overall)1786911076.90525878.5
 
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.