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

207 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
rhos7631906(None) 
hos68364191_hos
mhos95517771mhos
rho65924831rho_
rhus75114051rhus
abos67734412abos
ados57633512ados
ahis76135382ahis
ahoy101919182ahoy
ahs68644822ah_s
apos65433822apos
arvos86015662arvos
avos77227012avos
bios66335312bios
bohos105618252bohos
boos67955032boos
bos57966812_bos
brios74725722brios
broos75126412broos
bros65635662bros
chaos105622862chaos
chis95933312chis
chon96627792chon
chop116024922chop
chops125019872chops
chose105925402chose
chow125820992chow
chows135618202chows
cohos105921852cohos
coos67456492coos
cos510270392_cos
dhow116614002dhow
dhows125911222dhows
dos48062312_dos
duos56728132duos
echos105216462echos
egos55821652egos
epos66723732epos
eros45238452eros
ethos85514192ethos
ghis85020162ghis
ghost96318762ghost
goos57644912goos
gos47155132_gos
has67372652_has
hes66654202_hes
his66359502_his
ho510258272_ho_
hob87550922_hob
hobs97038982_hobs
hod76852462_hod
hods87239862_hods
hoe67562722_hoe
hoes75755732_hoes
hog78049062_hog
hogs87139662_hogs
hols76946292_hols
hon67759382_hon
hons77350782_hons
hop87554592_hop
hops97942632_hops
hose76547242_hose
host77852832_host
hot67776052_hot
hots78349322_hots
how97252432_how
hows106345602_hows
hoy97447912_hoy
hoys107733932_hoys
khis117017982khis
kos76944822_kos
loos49051122loos
mho86624622mho_
moos66051302moos
mos57067122_mos
naos47429732naos
nos38859322_nos
ohms95514032ohms
oho66534382oho_
ohs66232312oh_s
onos46229002onos
oohs75220692oohs
ordos65216202ordos
orzos143311252orzos
os211359882__os
phis95724902phis
phon95925382phon
phons105221142phons
phot95534352phot
phots105418492phots
poos65949112poos
praos74923562praos
pros65742782pros
rads56046602rads
rags55448372rags
rais45252622rais
rams65950772rams
raps66247732raps
ras37575392r_as
ratos55528762ratos
rats46260372rats
raws75238212raws
rays77642352rays
rebs65733562rebs
recs65734182recs
redos65126762redos
reds56042862reds
rees45364192rees
refs75732242refs
regs55436572regs
reis45343232reis
rems66237722rems
repos74725792repos
reps65937952reps
res35565042r_es
rets45352562rets
revs75027052revs
rhea75017432rhea
rheas84816952rheas
rhinos94411122rhinos
rhomb12399802rhomb
rhombs13336492rhombs
rias45540592rias
ribs65833012ribs
rids56539542rids
rifs74929002rifs
rigs55137592rigs
rims65936302rims
rins46153192rins
riot45947212riot
riots54922012riots
rips66237432rips
rob56754302r_ob
robs65837872robs
roc520243252r_oc
rocs65533662rocs
rod47953892r_od
rods56442062rods
roe36861072r_oe
roes45954132roes
rom59855632r_om
roms67038962roms
rood56733002rood
roods65125282roods
roof75738832roof
roofs85321152roofs
rook85532032rook
rooks95325042rooks
room66235082room
rooms75324682rooms
roose56127092roose
roost55730932roost
root45655922root
roots55933672roots
rose46148902r_ose
rosy76024872r_osy
rot37282952r_ot
rotos56027882rotos
rots46454092rots
row67453672r_ow
rows75941752rows
rubs66133492rubs
rues46044482rues
rugs56033682rugs
rums64833472rums
runs46438072runs
ruts44541492ruts
ryas77224612ryas
ryes75529352ryes
ryot75528562ryot
ryots85313782ryots
shes75734352shes
shod86225052shod
shoe75933432shoe
shoes85429652shoes
shog86025132shog
shogs95319702shogs
shoo75929882shoo
shoos84226352shoos
shop95629832shop
shops104222892shops
shot76150242shot
shots84730832shots
show106229182show
shows115324572shows
sos37761602_sos
taos45541002taos
this76027382this
tho67433962tho_
those85218142those
thou76722212thou
thous86017252thous
thus76721472thus
trios55528092trios
twos76718022twos
udos56619902udos
who95526772who_
whoa106615202whoa
whom127018172whom
whop125520922whop
whops135013932whops
whose114914532whose
whoso11509222whoso
whys137011662whys
woos76238802woos
wos66953532_wos
zoos135828802zoos

Search took 1 second 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 Filter178691298720.0762351197.4
2DLD Change Limit298722070.75039829.3
3Display Results2072070.0633285.7
 (SQL Overall)1786912070.889201002.2
 
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.