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 “roups” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

177 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
roups7511890(None) 
coups95522471coups
croups104312551croups
groups94210511groups
loups75319621loups
romps94617541romps
roues56039351roues
roup66627691roup_
roupy106112711roupy
routs57133411routs
soups75322941soups
bops86037982bo_ps
bouts75131312bouts
comps115526052comps
coops96229642coops
cops86751372co_ps
corps95927042corps
coup86729792coup_
coupe96023482coupe
coupes105022522coupes
crops96125232cro_ps
croup95616782croup_
croupe105114432croupe
croupes114613102croupes
croupy13458732croupy
cups85430822_cups
dorps85419222dorps
doums85417642doums
droops95110962droops
drops85719502dro_ps
drouks1137122drouks
dups75929512_dups
fops96532682fo_ps
fouls87221432fouls
fours85521492fours
goops86620962goops
gorps85316992gorps
gouts64826172gouts
group85413922group_
grouts75015612grouts
hoops105621072hoops
hops97942632ho_ps
hours85422382hours
jaups144810532jaups
jouks165612342jouks
kops107031292ko_ps
loops75723962loops
lops66043352lo_ps
louis57322322louis
loup66028432loup_
loupe75319512loupe
loupes84918052loupes
lours55125292lours
louts56330272louts
mops85940132mo_ps
moues75732842moues
nouns56717312nouns
nous46136982nou_s
oops65232672_oops
ops56641252_o_ps
opus66420592_opus
ouds56430102_ouds
ouph95618372_ouph
ouphs104311272_ouphs
ours47237562_ours
outs45746962_outs
pomps115316192pomps
poops94422412poops
pops86340952po_ps
poufs105616062poufs
pours74623182pours
pouts75530322pouts
props95726882pro_ps
pups86032232_pups
ramps96224632ramps
raps66247732r_aps
rasps74316662rasps
reaps75626192reaps
recoups1188842recoups
repps95114342repps
reps65937952r_eps
rhus75114052rhu_s
rips66237432r_ips
roads66523612roads
roams74919612roams
roans54926442roans
roars55622232roars
robes75133302robes
robs65837872ro_bs
rocks114626412rocks
rocs65533662ro_cs
rodes614039082rodes
rods56442062ro_ds
roes45954132ro_es
rogues74617672rogues
roils54826792roils
roles56747982roles
rolfs84817122rolfs
rolls55326232rolls
romp85926572romp_
roms67038962ro_ms
roods65125282roods
roofs85321152roofs
rooks95325042rooks
rooms75324682rooms
roots55933672roots
rope65542912ro_pe
ropes75940062ropes
ropy96323412ro_py
roques154912562roques
roses56445772roses
rotas54827722rotas
rotes56143902rotes
rotis56327052rotis
rotls55620162rotls
rotos56027882rotos
rots46454092ro_ts
roue45941742rou_e
rouen54920902rouen
rouens64814442rouens
rouge65423442rouge
rouges76022382rouges
rough97819432rough
roughs105416212roughs
round64318432round
rounds73615612rounds
rouped95717352rouped
roupet84218342roupet
rouse56634702rouse
rouses65436282rouses
roust55532062roust
rousts617016722rousts
rout46153282rou_t
route55132072route
routes66129312routes
routh86423072routh
rouths95416822rouths
roux117419362rou_x
roves84834482roves
rows75941752ro_ws
rubs66133492r_ubs
rues46044482r_ues
rugs56033682r_ugs
rumps95922292rumps
rums64833472r_ums
runs46438072r_uns
ruts44541492r_uts
scups95316652scups
soaps75120712soaps
sops65244562so_ps
souks94820522souks
souls55127362souls
soup66232912soup_
soupy106115402soupy
sours55230502sours
sous46947212sou_s
stoups85313272stoups
sups64834432_sups
tops66248122to_ps
tours55325862tours
touts54830392touts
tromps104911702tromps
troops85712772troops
troupe84812432troupe
troupes94112842troupes
trouts66116622trouts
tups65628762_tups
ups55629052__ups
vrouws12494742vrouws
whups134210002whups
woops104917522woops
wops96634152wo_ps
yaups105910742yaups
yours85217872yours
yous76230652you_s
yups96121602_yups
zouks184410502zouks

Search took 2 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 Filter178691538000.0931921408.6
2DLD Change Limit538001771.72031279.1
3Display Results1771770.0463847.8
 (SQL Overall)1786911771.85996122.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.