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

90 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
abusive124528(None) 
amusive1246251amusive
abrasive1345752abrasive
abuse77119562abus__e
abusing1049112abusing
abusively1743482abusively
allusive1144782allusive
elusive1057002elusive
unabusive1452352unabusive
abase76023483abas__e
abasia8712953abasi_a
abasias9711013abasias
abasing10610673abasing
abaxile1644083abaxile
abide86223713ab__ide
ablative1348243ablative
abortive1346883abortive
above105414323ab__ove
abrasives1444063abrasives
abscise1145953abscise
absolve1244513absolve
abubble1044523abubble
abulia83512503abuli_a
abulias93210693abulias
abulic106411423abuli_c
abusable1236373abusable
abused95614273abus_ed
abuser85413683abus_er
abusers94710553abusers
abuses85119103abus_es
active11313743a_ctive
adhesive1543803adhesive
adjustive2043243adjustive
alive85722513a__live
alsike1047913a_lsike
alumine9412693alumine
alunite7311633alunite
amative12311733amative
amosite9313163amosite
amuse75920833amus__e
amusia839173amusi_a
amusias938583amusias
amusing1039383amusing
aquiver1934753aqu_iver
arbuscle1242883arbuscle
archive154610483archive
arcsine94512393arcsine
arrive91311793a_rrive
arsine64021043a_rsine
aside65122083a__side
assize1538633a_ssize
assuasive1242623assuasive
audile73315303a_udile
augite7312613a_ugite
auspice1136523a_uspice
aversive1447443aversive
azurite1638003azurite
bauxite1635573bauxite
belive115415303_belive
beside95114613_beside
busied95117223_busied
busier85219723_busier
busies85525263_busies
busily112211503_busily
busing96420593_busing
bustle84015483_bustle
cursive1237833cursive
delusive1245843delusive
effusive1743263effusive
emulsive1344533emulsive
erosive1039193erosive
evasive1344663evasive
fusile94313493_fusile
illusive1144533illusive
infusive1445173infusive
jussive1734293jussive
massive12289773massive
missive122413143missive
obtrusive1443423obtrusive
passive12239593passive
pensive122610393pensive
plausive1344583plausive
plosive1236673plosive
rusine63916593_rusine
suasive1037853suasive
subside10410453subside
subsite9412873subsite
tensive10269913tensive
tussive1035303tussive
visive1257873_visive

Search took 8 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.423422437.4
2DLD Change Limit134027906.86019537.5
3Display Results90900.0303000.0
 (SQL Overall)178691907.31324434.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.