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

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

213 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
photog1237981(None) 
photo104417231photo_
photogs13358211photogs
photon1111514831photon
photos113316641photos
hotdog1134802_hotdog
phono104917022phono_
phonon114012032phonon
phonos114114792phonos
phot95534362phot__
photic133316442photic
photoed1338912photoed
photoing1439072photoing
photons123814432photons
phots105418502phot_s
phytol14366562phytol
phyton143610252phyton
prolog94212972prolog
proton84318892proton
aphotic142913123aphotic
apolog938903apolog
bhoot104322103bho_ot
bhoots11459913bhoots
chiton112612393chiton
cholo105217973cholo_
cholos114716853cholos
chook146015043cho_ok
chott103923933chot_t
chotts113610993chotts
cohog117813043_cohog
colog86619933_colog
croton84415453croton
dhooti1035663dhooti
dhoti9310123dhot_i
dhotis1038973dhotis
duolog835803duolog
hobo97026083_hobo_
hobos106321353_hobos
hog78049063_h__og
hogg96617533_ho_gg
homo96126473_homo_
homos105921783_homos
hong85833953_ho_ng
honor85718623_honor
hood85132333_ho_od
hoof106036583_ho_of
hook116133283_ho_ok
hoop96129983_ho_op
hoot75752103_ho_ot
hoots84830253_hoots
hooty115022443_hooty
hot67776063_hot__
hotbox1835703_hotbox
hotch136214733_hotch
hotdogs1234453_hotdogs
hotel85520753_hotel
hotly115815483_hotly
hotrod1048803_hotrod
hots78349333_hot_s
isolog737403isolog
koto86323473_koto_
kotos95717703_kotos
kotow12528713_kotow
lotos54724633_lotos
motor75317293_motor
panto76129413panto_
pantos85222743pantos
parton84720993parton
pastor84817483pastor
peloton938743peloton
pesto75723723pesto_
pestos84719083pestos
petto76021043petto_
phaeton1235973phaeton
phantom1436693phantom
pharos11312063pharos
phat95837863phat__
phatic133014413phatic
phenol1149253phenol
phenom1339473phenom
phlox1737333ph_lox
phobia13278603phobia
phobic153010073phobic
phoebe1335003phoebe
phon95925383ph__on
phonal11310383phonal
phone105621933pho_ne
phoned124014553phoned
phones114121213phones
phoney143612983phoney
phonic133315213phonic
phoning13312053phoning
phonons123310253phonons
phons105221143pho_ns
phony136715443pho_ny
phooey14379233phooey
photics142810483photics
photogene1547783photogene
photogram1748233photogram
photomap1745523photomap
photonic15312103photonic
photopia1549733photopia
photopic17411093photopic
photoset13414283photoset
pht86030523ph_t__
phut96925973phut__
phuts104613503phut_s
phylon14318033phylon
phytin14459013phytin
phytoid1678753phytoid
phytols15276553phytols
phytons15319063phytons
pinto75625753pinto_
pintos86021293pintos
pirog83913673p_irog
pistol83313333pistol
piston83515923piston
pistou83211843pistou
piton76121583p_iton
plot66141233plot__
plots75025673plot_s
plotty11208853plotty
plotz164617003plot_z
pluton838853pluton
poboy121612223p_oboy
poco86826153p_oco_
polo66236633p_olo_
polos76129913p_olos
pomo85828453p_omo_
pomos95321583p_omos
pong76231143p_o_ng
ponton83217643ponton
poo57757113p_o_o_
pood75934323p_o_od
poof95541663p_o_of
pooh96027383p_o_oh
pooing93820683pooing
pool65835953p_o_ol
poon67341263p_o_on
poop86532813p_o_op
poor65630223p_o_or
poos65949113p_o_os
postop10511943postop
pot58078433p_ot__
potage92715903p_otage
potboy1397813p_otboy
pothos114214693p_othos
potion84519573p_otion
pots66452363p_ot_s
potsy105815613p_otsy
potto75320943p_otto
pottos84615873pottos
potty105621003p_otty
poyou102611523p_oyou
pretor8315743pretor
proctor11310433proctor
prog75729003p__rog
proleg94612113proleg
prologs103512133prologs
prolong10319633prolong
promo95620003promo_
promos105116423promos
prong85218113pro_ng
pronto8313993pronto_
proof105221533pro_of
proso77222413proso_
prosos85718553prosos
protea82214763protea
protege1059153protege
protei82615313protei
protons93118003protons
protyl11308213protyl
prutot8311823prutot
ptotic102713373ptotic
punto75121323punto_
puntos85915793puntos
putlog965553putlog
puton73617913p_uton
putto75617663putto_
quohog1942503quohog
rhetor938063rhetor
rhotic112711233rhotic
rhyton12356113rhyton
roto45935053_roto_
rotor55519733_rotor
rotos56027883_rotos
shog86025143sh__og
sholom11910113sholom
shoo75929893sho_o_
shook124920163sho_ok
shool84523153sho_ol
shoon84022013sho_on
shoos84226363sho_os
shoot84235913sho_ot
shoots94619363shoots
shot76150263shot__
shote85526103shot_e
shotes95321913shotes
shots84730853shot_s
shott85332193shot_t
shotts93614703shotts
sotol54917653_sotol
tautog765713tautog
theolog1146153theolog
tholoi9339233tholoi
tholos94213003tholos
thong95014183tho_ng
thoro86217873thoro_
thoron94713903thoron
tog410255043___tog
whoof144612693who_of
whoop134211443who_op
whoso11509223whoso_

Search took 5 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127162134.58024610.5
3Display Results2132130.0603550.0
 (SQL Overall)1786912134.78037383.1
 
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.