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

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
stopover134406(None) 
stopovers1443831stopovers
flopover1642862flopover
popover1495842_popover
slipover1343832slipover
stooker113811732sto_oker
stooper93813192sto_oper
stoper84320102stop__er
stopper113012602stop_per
stover94115642st__over
flopovers1742563flopovers
groover11358543gro_over
hoover124314433_ho_over
popovers1595663_popovers
proposer121810633proposer
scooper113812033sco_oper
scooter93312873sco_oter
shooter103013993sho_oter
shopper143312633shop_per
shover124515993s__hover
sleepover1442593sleepover
slipcover1642093slipcover
slipovers1443463slipovers
sloper84615913slop__er
sloppier1255713sloppier
snooker113910303sno_oker
snooper93511533sno_oper
snoopier10177273snoopier
snoozer16409193sno_ozer
soever94412093s_o_ever
solver94016703s_o_lver
sooner64220463s_o_oner
sopor74016493s_opo__r
soppier112711583s_oppier
spoofer12368723spo_ofer
spooler93711383spo_oler
stapler93913633stap_ler
starver104611993st_arver
stepper113010853step_per
stippler1235543stippler
stiver93915733st__iver
stocker133713083sto_cker
stockier14217253stockier
stodgier1034223stodgier
stoker104417623st__oker
stolider936603stolider
stomodea1143623stomodea
stomper114111233sto_mper
stoner65823203st__oner
stonier72013793sto_nier
stooge73811663sto_oge_
stooged94310733sto_oged
stooges83611483sto_oges
stooked124312303sto_oked
stookers12449793sto_okers
stooled84313893sto_oled
stooped103813833sto_oped
stoopers103711303sto_opers
stope74727243stop__e_
stoped94721013stop__ed
stopers94217373stop__ers
stopes84525893stop__es
stopoff1565023stopo_ff
stopoffs1662993stopoffs
stopped124512203stop_ped
stoppers123910593stop_pers
stopple1156583stopple_
stoppled1345003stoppled
stopples1236953stopples
storer64721673st__orer
stormier1036103stormier
stouter74012053sto_uter
stove85220253st__ove_
stovers103713733st__overs
stoves93818923st__oves
striver104315203st_river
stroker114113523st_roker
stropper1247763strop_per
stroppier1364453stroppier
strove95014793st_rove_
stroyer103510783st_royer
stuiver10447083st_uiver
stupider1133913stupider
stupor836013stupo__r
supposer1245593supposer
swooner10358673swo_oner
swooper12389173swo_oper
swoopier13175143swoopier
tooler63818613_to_oler
tooter64420803_to_oter
toper75231023_top__er
topper103817603_top_per
trover95014663_t_rover

Search took 9 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.410435831.7
2DLD Change Limit146162937.64019131.2
3Display Results93930.0303100.0
 (SQL Overall)178691938.08022115.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.