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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

93 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
abuse7711956(None) 
abase76023481abase
abused95614271abused
abuser85413681abuser
abuses85119101abuses
amuse75920831amuse
abas68642082abas_
abased96514992abased
abaser86414342abaser
abases85720772abases
abash106016512abash
abate76627842abate
abbe87627182ab_be
abbes96723522abbes
abduce1197192abduce
abele76323252abele
abide86223702abide
abjure1536732abjure
able66340532ab_le
ables75935542ables
ablush1147222ablush
abode85518812abode
abos67734412abos_
above105414322above
abs59356072ab_s_
abusers94710552abusers
abusive1245282abusive
abut66834952abu_t
abuts75417072abuts
abuzz15517212abuzz
abye97921002ab_ye
abyes105518532abyes
abys97221882abys_
abysm12598142abysm
abyss10669462abyss
accuse103411032accuse
acute74720362acute
adust64117452adust
ague55725922agu_e
agues64919052agues
ambush1336102ambush
amus65529612amus_
amused94412512amused
amuser84712622amuser
amuses85117942amuses
anise55129702anise
anus47131112anus_
anuses66218772anuses
apse67725382a_pse
aquae142212712aquae
arbute8311042arbute
arise56436432arise
arose55832082arose
arouse65019982arouse
arse46539272a_rse
avulse935842avulse
azure14911482azure
babus95620332babus_
base64847022_base
bise66437092_bise
bouse75931852bouse
burse75527252_burse
bus56950972_bus_
bused85624492_bused
buses75936012_buses
bush96630712_bush
busk105429222_busk
buss65134912_buss
bust65947782_bust
busy94727172_busy
bute66739672_bute
cause75225352cause
cayuse11207762cayuse
cruse75726102cruse
douse66329722douse
druse64817662druse
fuse76429992_fuse
habus106317142habus_
house89131422house
louse56131012louse
mouse77133002mouse
muse67136032_muse
obese75212422obese
obtuse8147482obtuse
pause75021832pause
reuse56025362reuse
rouse56634702rouse
ruse45938932_ruse
souse56530772souse
tabus74820922tabus_
touse55430672touse
use36835162__use
youse85322232youse

Search took 3 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 Filter178691538000.1261418182.5
2DLD Change Limit53800931.89028465.6
3Display Results93930.0303100.0
 (SQL Overall)178691932.04687336.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.