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

271 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
photics14281048(None) 
phobics16286701phobics
phonics143110721phonics
photic133316441photic_
aphonics15259522aphonics
aphotic142913122aphotic_
biotics113812172biotics
dhotis1038972dhoti_s
erotics91914152erotics
exotics16229192exotics
miotics112710652miotics
myotics14257602myotics
peptics132610242peptics
phatic133014412phatic_
phobias14228182phobias
phobic153010072phobic_
phonetics1646732phonetics
phonic133315212phonic_
phonies123717512phonies
photogs13358212photogs
photonics1649352photonics
photons123814432photons
photos113316642phot_os
phots105418502phot__s
physics17265962physics
phytins15317892phytins
poetics11312072poetics
ptotic102713372ptotic_
rhotic112711232rhotic_
antics84621453_antics
aphasics15257243aphasics
aphetic142912853aphetic_
aphonias132611143aphonias
aphonic142713393aphonic_
aprotic112715243aprotic_
arctics1138953arctics
atomics113110853atomics
atonics93613713atonics
attics84413283_attics
azotic172711633azotic_
bionics114310873bionics
biopics13318543biopics
biotic103816613biotic_
biotins93114453biotins
booties94124613booties
bustics11810883bustics
chaotic14310043chaotic_
chemics16349583chemics
chics123920943ch__ics
chitins122713793chitins
choice132010523cho_ice
choices142010613cho_ices
choirs114911883cho_irs
chopins142312243chopins
choric133515903choric_
chotts113610993chot_ts
chronics1538683chronics
chymics19295533chymics
clitics11279973clitics
colics104219903_colics
comics124015563_comics
conics103920593_conics
cooties93725733cooties
cretics112911653cretics
critics112811093critics
demotics1338753demotics
dhobis1236113dhobi_s
dhooties1237643dhooties
dhootis1135683dhooti_s
dhoti9310123dhoti__
dhutis1035943dhuti_s
ebonics1137193ebonics
emetics11610723emetics
erotic82620273erotic_
erotica92811513erotica
euphotic15117523euphotic_
exotic153112653exotic_
exotica16257603exotica
footies103721543footies
frolics1236833frolics
fustics1279593fustics
gnostics1146323gnostics
gothics1336123_gothics
hogties112813993_hogties
hoick145210683_ho_ick
hoicks15378283_ho_icks
holies94630033_holies
homies114524733_homies
hotch136214733_hot_ch
hotels94515523_hotels
hots78349333_hot__s
hotties103016963_hotties
hypnotics1944443hypnotics
ionics84214483_ionics
kyphotic2245773kyphotic_
logics95711123_logics
lotic76420673_lotic_
luetics937323luetics
mastics112614783mastics
miotic103715753miotic_
motifs1139673_motifs
myotic133112313myotic_
mystics14279103mystics
nephrotics1743883nephrotics
notice8313443_notice
notices9312283_notices
ootids71110353_ootids
ophitic1439213ophitic_
optics102810183_optics
orthotics1445433orthotics
otic66624823__otic_
ovonics12245553ovonics
panics103815363p_anics
panties94230933panties
paretics122312443paretics
parotic112518043parotic_
parotids112610413parotids
parties93230873parties
pasties94529813pasties
pastils94416173pastils
pastis84924323pasti_s
patins87528783p_atins
patios85221793p_atios
patois84319363patoi_s
patties93425143patties
pectic122913873pectic_
pectins112315233pectins
pelvics14245643pelvics
peonies93620153peonies
peptic122113153peptic_
peptids12239333peptids
phasic133612053phasic_
phasis114614923phasi_s
phenetics1646483phenetics
phenolics1645053phenolics
phimotic1747153phimotic_
phis95724903ph__i_s
phobia13278603phobi_a
phocine1438833phocine
phoebes1435813phoebes
phoebus1443823phoebus
phonemics1844933phonemics
phones114121213pho_nes
phonetic15310323phonetic_
phoneys15437143phoneys
phonied133710563phonied
phonier122710633phonier
phoniest132811543phoniest
phonily1537103phonily
phoning13312053phoning
phonons123310253phonons
phonos114114793pho_nos
phons105221143pho__ns
phot95534363phot___
photo104417233phot__o
photoed1338913photoed
photog12379813phot_og
photoing1439073photoing
photon1111514833phot_on
photonic15312103photonic_
photopias16410143photopias
photopic17411093photopic_
phuts104613503phut__s
phyletics1944583phyletics
phylic16279553phylic_
physic16288473physic_
physis14359663physi_s
phytin14459013phyti_n
phytols15276553phytols
phytons15319063phytons
picnics13297343picnics
pics85633923p___ics
pieties9419223pieties
pionic103515953pionic_
pistils93314303pistils
pities83828083p_ities
plastics122412333plastics
platies93722543platies
plots75025673plot__s
plotties103111413plotties
plotzes18317703plotzes
poetic10416843poetic_
pogies94123543p_ogies
pois66539043p_o_i_s
pokies125921333p_okies
police102918563p_olice
polices113118053p_olices
policy133211513p_olicy
polies84034583p_olies
polios84019723p_olios
polis74731163p_oli_s
politics122513813politics
ponies84833463p_onies
pontils9312213pontils
pooris83916843poori_s
portico11310143portico
porticos1238383porticos
posies84431433p_osies
posits85718713p_osits
posties93128813posties
postins93721203postins
pothos114214693p_othos
potiche1438043p_otiche
potiches1539203p_otiches
potion84519573p_otion
potions93417423p_otions
potpies113116173p_otpies
pots66452363p_ot__s
potsies93019483p_otsies
potties93723543potties
pottos84615873p_ottos
probits112712573probits
profits122911243profits
prosties101421193prosties
proteas92015123proteas
protect11313633protect
protects1239743protects
proteids11259953proteids
proteins102114283proteins
proteus92511593proteus
protist9320223protist
protists10313363protists
protium11312293protium
protiums1238563protiums
protons93118003protons
protyls12298463protyls
proxies163014933proxies
psoatic1139303psoatic_
psocids1234863psocids
psychotics2255563psychotics
ptosis83611823ptosi_s
publics13207143publics
punties94520783punties
putties94420023putties
pyknics1842483pyknics
pyosis114012123pyosi_s
rhodic12227233rhodic_
robotics1245493robotics
rotis56327063_roti_s
rustics9810733rustics
scotias939753scotias
septics112810433septics
shogis103810943shogi_s
shojis16348493shoji_s
shortias1148093shortias
shorties11414583shorties
shotes95321913shot_es
shots84730853shot__s
shotts93614703shot_ts
shtick15308023sh_tick
shticks16356963sh_ticks
shtiks13297833sh_tiks
sonics84315633_sonics
spastics1237503spastics
spherics1537073spherics
statics93314533statics
stoics8311113sto_ics
stotins73213873stotins
tactics1149323tactics
thetic11412893thetic_
thorias102312053thorias
thoric114314043thoric_
tics65729643___tics
tonics83617863_tonics
topics104714583_topics
torics85118353_torics
toxics153910203_toxics
tropics113610653tropics
whities133113253whities
whosis1237173whosi_s
zloties1639913zloties

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 Filter1786911340270.420425454.8
2DLD Change Limit1340272716.78319759.3
3Display Results2712710.0932914.0
 (SQL Overall)1786912717.29624491.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.