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

263 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
photoing143907(None) 
hoboing13309452_hoboing
hooting113919882_hooting
hotting113116522_hotting
phoning13312052pho_ning
phonying1745832phonying
photog12379812photo__g
photon1111514832photo_n_
photonic15312102photonic
photons123814432photo_ns
plotting113011012plotting
plotzing20276152plotzing
pooing93820682p_o_oing
potting103720892p_otting
promoing13310462promoing
shooing112112912sho_oing
shooting122812862shooting
shotting123012382shotting
autoing8314043_autoing
blotting113910433blotting
booing94521643_bo_oing
booting103821363boot_ing
chatting142810143chatting
chitling142910663chitling
chocking204011013chocking
choiring14279793choiring
choking173911943cho_king
chomping18339883chomping
choosing142010133choosing
chopping183710263chopping
chording15410153chording
choring133617663cho_ring
chortling1535563chortling
chousing14259423chousing
chowing164412773cho_wing
chowsing17217343chowsing
chuting132910733chut_ing
clothing14278783clothing
clotting113110643clotting
cooing94024923_co_oing
coting94629253_cot_ing
dittoing1036263dittoing
doting84821913_dot_ing
dotting93314483_dotting
emoting10313563emot_ing
footing115017593foot_ing
footling12239923footling
frothing15208533frothing
ghettoing1442123ghettoing
ghosting1336463ghosting
haloing113814133_haloing
hating104929713_hat_ing
hatting113920233_hatting
hitting113017273_hitting
hoaxing18307763_hoaxing
hobbing152811123_hobbing
hocking173417243_hocking
hoeing104117023_ho_eing
hogging133112803_hogging
hogtying1633553_hogtying
hoising113414413_hoising
hoking144419513_ho_king
holding123514283_holding
holing104025073_ho_ling
holking153512313_holking
holloing12148823_holloing
homing123718383_ho_ming
honing103421503_ho_ning
honking153414793_honking
honoring12310473_honoring
hooding123815203_hooding
hoofing143912553_hoofing
hooking153716693_hooking
hooping133615703_hooping
hoping123719743_ho_ping
hopping154115273_hopping
hording123517053_hording
horning113015003_horning
horsing113215583_horsing
hosing103421103_ho_sing
hosting114318383_hosting
hotching17309313_hotching
hotline10712353_hotline
hotlink1476763_hotlink
housing113316523_housing
howking183610313_howking
howling143413163_howling
hutting113016033_hutting
hypoing1636503_hypoing
jotting152912773_jotting
knotting13236573knotting
kotowing1634013_kotowing
locoing102810973_locoing
looing73621043_lo_oing
looting83019643loot_ing
lotting82917753_lotting
mooing93718373_mo_oing
mooting103019363moot_ing
motoring11410953_motoring
nothing113511903_nothing
noting74120153_not_ing
panting104025423pant_ing
parting103527383part_ing
partying14168893partying
pasting103826553past_ing
pastoring12310853pastoring
patting103722343p_atting
pelting102917273pelt_ing
peopling1338353peopling
pestling111010253pestling
petting103720953p_etting
pettling1168213pettling
pharming16248143pharming
phasing133211673ph_asing
philtring1544173philtring
phocine1438833pho_cine
phonating1537813phonating
phoneying1844283phoneying
phonon114012033phono_n_
phonons123310253phono_ns
phoronid1449073phoronid
photic133316443phot_i_c
photics142810483phot_ics
photo104417233photo___
photoed1338913photo_ed
photogene1547783photogene
photogs13358213photo_gs
photolyzing2953873photolyzing
photomap1745523photomap
photonics1649353photonics
photopia1549733photopia
photopias16410143photopias
photopic17411093photopic
photos113316643photo__s
photoset13414283photoset
phrasing1438013phrasing
phytin14459013phyt_in_
phytins15317893phyt_ins
phytoid1678753phytoi_d
phyton143610253phyto_n_
phytonic1848203phytonic
phytons15319063phyto_ns
picoting1338883picot_ing
piloting1139693pilot_ing
pistoling1268493pistoling
pithing134014053p_ithing
pitting103618873p_itting
pitying132910243p_itying
pivoting1436183pivot_ing
plating103823073plat_ing
platting114813033platting
plodding13166343plodding
plonking15358563plonking
plopping12318703plopping
plotline1037643plotline
plowing133111723plo_wing
ploying132811573plo_ying
pocking163916763p_ocking
podding124113183p_odding
poising103617103p_oising
poking133819303p_o_king
poling93526503p_o_ling
polling102920383p_olling
poncing122913583p_oncing
ponding114317083p_onding
ponging113416153p_onging
ponying133312123p_onying
pooching16328983pooching
poohing133112323p_oohing
pooling103219093p_ooling
pooping123615443p_ooping
popping113715413p_opping
poring94227273p_o_ring
porking143515813p_orking
porting103021783p_orting
posing93922643p_o_sing
posting105622243p_osting
potion84519573p_otion_
potions93417423p_otions
potline91015233p_otline
pouring103115863p_ouring
pouting103519943p_outing
poxing163714943p_o_xing
prating103424453prat_ing
probing123314443pro_bing
proctoring1546673proctoring
prodding13189343prodding
progging132610383progging
prologing1338953prologing
prolong10319633prolo_ng
promoting1439923promoting
pronging123511843pronging
proofing1439313proofing
proponing1439993proponing
proposing1439673proposing
propping122811673propping
prosing103319383pro_sing
protein92414733protein_
proteins102114283proteins
proton84318893proto_n_
protonic12314593protonic
protons93118003proto_ns
proving134214073pro_ving
provoking1935133provoking
prowling1449993prowling
punting103318443punt_ing
putting103218573p_utting
puttying1434953puttying
putzing19359123p_utzing
quoting17310043quot_ing
rioting82716393riot_ing
rooting83522433root_ing
rootling9269953rootling
rotting82919683_rotting
scooting113012643scooting
shitting123212663shitting
shoaling123111753shoaling
shocking184311543shocking
shoeing113211883sho_eing
shogging14308023shogging
shooling123012563shooling
shootings13266063shootings
shopping163611293shopping
shoring112820073sho_ring
shorting122514803shorting
shouting122711793shouting
shoving142910643sho_ving
showing143814663sho_wing
showring1548323showring
shuting113212053shut_ing
shutting12309693shutting
slotting92612613slotting
snooting92813203snooting
soloing82813803_soloing
soothing12269973soothing
sooting82820963soot_ing
spotting112812093spotting
stotting92811163stotting
swotting12268483swotting
tholing112812333tho_ling
thorning1237513thorning
thouing11258603tho_uing
toothing12278863toothing
tooting83019423toot_ing
tootling9279523tootling
toting74123793_tot_ing
totting82816843_totting
trothing122410843trothing
trotting92510913trotting
upholding1643373upholding
uprooting1276903uprooting
upshooting1642553upshooting
vetoing11309053_vetoing
voting103916033_vot_ing
whetting1535973whetting
whiting143311303whit_ing
whomping19285943whomping
whoofing18234833whoofing
whooping17286633whooping
whopping19357373whopping
whoring142910293who_ring
wooing104214663_wo_oing
wotting112913843_wotting

Search took 8 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.406440125.6
2DLD Change Limit1461622637.23320207.7
3Display Results2632630.0932828.0
 (SQL Overall)1786912637.73223110.6
 
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.