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

133 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
sportif123880(None) 
shortia1048192shortia
shortie10411342shortie
sortie63621992s_ortie
sporoid102310732sporoid
sport75935982sport__
sported104015432sported
sporter93616552sporter
sportier102010052sportier
sportily1337732sportily
sporting112415462sporting
sportive1348332sportive
sports84619182sport_s
sporty115112492sport_y
aortic8316613_aortic
aperitif1347343aperitif
aporia8315863apor_ia
aport75432173aport__
apostil947903apostil
aprotic112715243aprotic
cortin82423153_cortin
fortify1636523_fortify
fortis95418613_fortis
mortify1536223_mortify
motif10519683_mo_tif
poetic10416843_poetic
pontiff1547903_pontiff
pontil8315463_pontil
port66059633_port__
portal84218463_portal
ported94223243_ported
porter84224413_porter
portico11310143_portico
porting103021783_porting
portion9615493_portion
portly114713403_portly
ports75934593_port_s
postie84123963_postie
postin83521033_postin
psoatic1139303psoatic
scoria8513503scor_ia
scorify1535203scor_ify
scotia8310803sco_tia
scottie937463scottie
serif84132133s_er_if
sharif122917123shar_if
sherif122915243sher_if
short85040533short__
shorted113614403shorted
shorten103511413shorten
shorter103515503shorter
shortias1148093shortias
shorties11414583shorties
shorting122514803shorting
shortish1437423shortish
shortly13387573shortly
shorts95321743short_s
shorty124313203short_y
skort94925643skort__
skorts104211303skort_s
smartie9310173smartie
snort54833753snort__
snorted83813493snorted
snorter74412663snorter
snorting92613373snorting
snorts64116503snort_s
softie93312483s_oftie
sorbic10310393s_orbic
sordid83411163s_ordid
sori46039843s_or_i_
soritic91414433s_oritic
sort46264813s_ort__
sorta57125413s_ort_a
sorted74523713s_orted
sorter64425093s_orter
sortied83314103s_ortied
sorties74126403s_orties
sorting83221813s_orting
sorts54536663s_ort_s
sparid94016933spar_id
sparoid102311543sparoid
spartan948333spartan
spartina1037983spartina
spastic11310383spastic
spermic1338523spermic
spirit83519923spir_it
spirits94112623spirits
spiroid10219823spiroid
spirt75032953spirt__
spirted103913073spirted
spirting112913633spirting
spirts85317133spirt_s
spoil75818653spo__il
spongin1036373spongin
spoof105019013spo__of
sporadic1345053sporadic
sporal82915453spor_al
spore75428593spor__e
spored94821793spor_ed
spores84726613spor_es
sporing104319413sporing
sporran936743sporran
sporters103714063sporters
sportful1344513sportful
sportiest111711033sportiest
sporule937273sporule
spot65540693spo_t__
spotlit947303spotlit
spots74424113spo_t_s
spotted103713143spotted
spotter94514883spotter
spottier10207313spottier
spottily1335153spottily
spotting112812093spotting
spotty11448583spo_tty
spout75029633spout__
spouted103412263spouted
spouter94213223spouter
spouting113511953spouting
spouts85115113spout_s
sprain83614863sp_rain
sprig85617743sp_r_ig
sprit76736403sp_r_it
sprite84421773sp_rite
sprits85122533sp_rits
spritz174714423sp_ritz
spurt77227983spurt__
spurted103111973spurted
spurter94013003spurter
spurting113111633spurting
spurtle937453spurtle
spurts84814973spurt_s
stotin63215063sto_tin

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.610292936.1
2DLD Change Limit1340271336.20021617.3
3Display Results1331330.0502660.0
 (SQL Overall)1786911336.86026048.3
 
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.