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

100 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
sportive134833(None) 
abortive1346882abortive
shortie10411342shorti_e
sorptive1346472s_orptive
sortie63621992s_orti_e
sportier102010052sportier
sportif1238802sporti_f
sportily1337732sportily
sporting112415462sporting
sportively1845022sportively
supportive1753282supportive
adoptive1445503adoptive
amortise10428513amortise
amortize1987743amortize
aspersive1445893aspersive
assertive1246473assertive
costive12312843_costive
emotive1239193emo_tive
exertive1839083exertive
extortive1945143extortive
forgive1436193_forgive
furtive1337173_furtive
mortice11711493_mortice
mortise9713533_mortise
motive113112143_mo_tive
operative141110553operative
optative1347653optative
partite9317133_partite
poetise9314043_poetise
poetize18310773_poetize
pontine92419053_pontine
porcine11312843_porcine
portage103013643_portage
portative1449373_portative
portico11310143_portico
portiere1038773_portiere
porting103021783_porting
portion9615493_portion
portside1138163_portside
positive1349993_positive
postdive1445763_postdive
postie84123963_posti_e
poutine93316823_poutine
sanative11310473sanative
scoriae9310903scor_iae
scottie937463scotti_e
scrive115414943s_cr_ive
secretive1446933secretive
sedative1238853sedative
separative1546973separative
serotine8313573serotine
shortage1236313shortage
shortia1048193shorti_a
shortias1148093shortias
shorties11414583shorties
shorting122514803shorting
shortish1437423shortish
shortwave1842483shortwave
showtime1643773showtime
shrive125216953s_hr_ive
smartie9310173smarti_e
snorting92613373snorting
softie93312483s_ofti_e
sordine82515233s_ordine
sortied83314103s_ortied
sorties74126403s_orties
sorting83221813s_orting
sparlike1437673sparlike
sparteine1185483sparteine
spartina1037983spartina
spermine12311433spermine
spirting112913633spirting
spore75428593spor___e
sporicide1484793sporicide
sporing104319413spor_ing
sporoid102310733sporoi_d
sport75935983sport___
sported104015433sport_ed
sporter93616553sport_er
sporters103714063sporters
sportful1344513sportful
sportiest111711023sportiest
sportiness1278233sportiness
sports84619183sport__s
sportsmen1343543sportsmen
sporty115112493sport__y
sporulative1653743sporulative
sporule937273spor_ule
spottier10207313spottier
spottily1335153spottily
spotting112812093spotting
spouting113511953spouting
sprite84421773sp_r_ite
spurting113111633spurting
spurtle937453spurt_le
stative102612933s_tative
strive95020963s_tr_ive
survive1335933s_urvive
tortile7313193_tortile
votive12348933_vo_tive

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 Filter1786911461620.436409841.7
2DLD Change Limit1461621006.56322270.6
3Display Results1001000.0462173.9
 (SQL Overall)1786911007.04525364.2
 
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.