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

96 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
stroppier136445(None) 
strappier1345131strappier
stropper1247761stropp_er
scrappier1544422scrappier
sloppier1255702s_loppier
soppier112711582s__oppier
stopper113012602st_opp_er
strapper1258092strapp_er
stripier1058862str_ipier
stripper1247122stripp_er
stropped1367342stropp_ed
stroppers1356712stropp_ers
stroppiest1444562stroppiest
stropping1436932stropping
trippier1246622_trippier
atrophied1546063atrophied
atrophies14410093atrophies
choppier17286643_choppier
crappier14288133_crappier
cropper133312963_cropp_er
croppie13278793_croppie_
croppies143111133_croppies
croupier1246883_croupier
drippier1385043_drippier
droopier1145573_droopier
dropper12329873_dropp_er
floppier1554633_floppier
gloppier1354673_gloppier
grippier1355203_grippier
hoppier143110703__hoppier
loppier11369723__loppier
preppier1156643_preppier
ropier84118803__ro_pier
roupier9319493__roupier
sappier113613113s__appier
scrapper1466973scrapp_er
scrimpier1554243scrimpier
scroggier1343133scroggier
shopper143312633s_hopp_er
shrimpier1643063shrimpier
sirupier1034303sir_upier
slippier1256533s_lippier
snappier1266213s_nappier
snippier1255793s_nippier
snoopier10177273s_noopier
soapier93411713s__oapier
soupier93111753s__oupier
stepper113010853st_epp_er
stippler1235543st_ippler
stockier14217253st_ockier
stodgier1034223st_odgier
stomper114111233st_omp_er
stonier72013793st_o_nier
stooper93813193st_oop_er
stoper84320103st_o_p_er
stopover1344063st_opover
stopped124512203st_opp_ed
stoppers123910593st_opp_ers
stopping133611413st_opping
stopple1156583st_opple_
stoppled1345003st_oppled
stopples1236953st_opples
stormier1036103st_ormier
strapped1357823strapp_ed
strappers1346743strapp_ers
strappiest1444373strappiest
strapping1436993strapping
strawier1137493str_awier
streakier1334843streakier
streamier1155763streamier
stringier1036713stringier
striper94514793str_ip_er
stripped1357093stripp_ed
strippers1355773stripp_ers
stripping1436493stripping
stroker114113523stro__ker
stroller848173stro_ller
stronger9349693stro_nger
strophe1239143stro_phe_
strophes13310603stro_phes
strophic1569003strophi_c
stroppy14205093stropp__y
stroyer103510783stro__yer
stumpier1255883st_umpier
swoopier13175143s_woopier
syrupier1343053syr_upier
tippier113210543_t_ippier
topper103817603_t_opp_er
trampier12318243_trampier
trapper113912803_trapp_er
tripper113711923_tripp_er
trooper94210363_troop_er
trophied1437643_trophied
trophies13413673_trophies
trouper93811433_troup_er
troutier8277153_troutier

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 Filter1786911486410.423422437.4
2DLD Change Limit148641967.17320722.3
3Display Results96960.0462087.0
 (SQL Overall)178691967.64223382.8
 
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.