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

186 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
purrs7532043(None) 
burrs74925651burrs
currs75624391currs
durrs65519991durrs
murrs75521291murrs
parrs75928671parrs
puris75332021puris
purls74723351purls
purr64925811purr_
purs65641041pu_rs
auras55932552auras
aures55137092aures
auris55331522auris
birrs74917102birrs
buhrs104811242buhrs
buras74736292buras
burbs95423492burbs
burds84626062burds
burgs84924092burgs
burls74228852burls
burns74926772burns
burps94220172burps
burr65631232burr_
burro75018492burro
burros85114992burros
burry105221562burry
burs65847422bu_rs
carrs75730852carrs
churrs115111512churrs
curbs94821652curbs
curds85725612curds
curers84923182curers
cures75645432cures
curfs105122142curfs
curls74927102curls
curns74924272curns
curr65429652curr_
curry105920342curry
curs65645542cu_rs
dorrs65520592dorrs
duras65727722duras
dures65635922dures
durns64819862durns
duros65422692duros
durr55624352durr_
durra65315792durra
durras74713372durras
errs45622532_errs
euros54920242euros
furls85322052furls
furors9310952furors
furry116719282furry
furs76735042fu_rs
guars65021042guars
gurry94515412gurry
gurus64318192gurus
hurds95219072hurds
hurls86522712hurls
hurry114917182hurry
hurts86922822hurts
jurors1338282jurors
kurus98015632kurus
lurers64217492lurers
lures56138532lures
lurks95218742lurks
muras75329562muras
mures75937212mures
murks114821722murks
murr65225132murr_
murra74519082murra
murras84916002murras
murre74821072murre
murres85019042murres
murry105120232murry
nurds65518522nurds
nurls55519682nurls
ours47237562ou_rs
pairs75325832pairs
paras76143042paras
pards85634332pards
parers85530742parers
pares77164482pares
paris75145942paris
parks116134462parks
parr65731152parr_
parry105323752parry
pars67560792p_ars
parts77743372parts
pears75138612pears
peers75130272peers
peres76246642peres
peris75537072peris
perks115325802perks
perms95524512perms
perps95521482perps
perry105222712perry
pervs105117372pervs
piers75926332piers
pirns76020092pirns
pores75849032pores
porks115124142porks
porns75527342porns
ports75934592ports
pourers93513672pourers
pours74623182pours
pros65742782p_ros
pubes94423402pubes
pubis94616472pubis
pubs85029212pu_bs
puces94924632puces
pucks134322102pucks
puds75630512pu_ds
puffs134114932puffs
pugs76332772pu_gs
pujas145513322pujas
pukes114523022pukes
pulers83820282pulers
pules74538812pules
pulis74225602pulis
pulls74425052pulls
pulps95116482pulps
puls65437562pu_ls
pumas95121562pumas
pumps115520602pumps
punas74826752punas
pungs85422222pungs
punks114822682punks
puns66641482pu_ns
punts75828002punts
pupas95219282pupas
pups86032232pu_ps
pupus94614042pupus
pur56840552pu_r_
purda82914692purda
purdas92612262purdas
pure65543332pu_re
puree74632842puree
purees84721682purees
purer75127902purer
purest84021932purest
purge85324602purge
purgers104714002purgers
purges94421762purges
puri65931442pu_ri
purin75527592purin
purins83722652purins
purism104715062purism
purist85525052purist
purl65631422pu_rl
purred94218072purred
purse76028892purse
pursers93916092pursers
purses84826372purses
pursy105016412pursy
purty105019402purty
pus55547842pu__s
puses75532202puses
puss64830132pu_ss
puts65641752pu_ts
putts75719272putts
pyres105523882pyres
pyros105718292pyros
ruers515019412ruers
spurns84811382spurns
spurry11429112spurry
spurs74621522spu_rs
spurts84814972spurts
suers55128482suers
suras55336322suras
surds65624662surds
surfs85022542surfs
surra55521342surra
surras65919532surras
torrs53923562torrs
turds65021692turds
turfs84620442turfs
turks95320822turks
turns55623232turns
turps74918732turps
urbs65922052_urbs
urds55922422_urds
urns46323892_urns
urps66920472_urps
urus46426132_urus
yirrs8469192yirrs
yurts87216532yurts

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 Limit538001861.71631352.0
3Display Results1861860.0503720.0
 (SQL Overall)1786911861.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.