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

156 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
phobics1628670(None) 
phobias14228181phobias
phobic153010071phobic_
phonics143110721phonics
photics142810481photics
aphonics15259522aphonics
dhobis1236112dhobi_s
phobia13278602phobi_a
phonic133315212phonic_
phonies123717512phonies
photic133316442photic_
physics17265962physics
probits112712572probits
aerobics1246833aerobics
aphasics15257243aphasics
aphonias132611143aphonias
aphonic142713393aphonic_
aphotic142913123aphotic_
atomics113110853atomics
atonics93613713atonics
bionics114310873bionics
biopics13318543biopics
biotics113812173biotics
boobies113718203boobies
chebecs1635013chebecs
chemics16349583chemics
chics123920943ch__ics
choice132010523cho_ice
choices142010613cho_ices
choirs114911883cho_irs
chopins142312243chopins
choric133515903choric_
chronics1538683chronics
chymics19295533chymics
cobias104014993_cobias
colics104219903_colics
comics124015563_comics
conics103920593_conics
cubics123810163_cubics
dhobi1136973dhobi__
dhotis1038973dhoti_s
dobies94422093_dobies
doobies103915673doobies
ebonics1137193ebonics
ephebic1646513ephebic_
erotics91914153erotics
exotics16229193exotics
frolics1236833frolics
globins10278953globins
gobies95418063_gobies
habits113014653_habits
hobbies143813343_hobbies
hobbits14317553_hobbits
hoboes114717453_hoboes
hobos106321353_hob_os
hobs97038983_hob__s
hoick145210683_ho_ick
hoicks15378283_ho_icks
holies94630033_holies
homies114524733_homies
iambics13425643iambics
ionics84214483_ionics
logics95711123_logics
loobies93814103loobies
miotics112710653miotics
myotics14257603myotics
niobic1037243niobic_
obias76116863__obias
obis66226843__obi_s
obits74617553__obits
ovonics12245553ovonics
panics103815363p_anics
pelvics14245643pelvics
peonies93620153peonies
peptics132610243peptics
phasic133612053phasic_
phasis114614923phasi_s
phatic133014413phatic_
phenolics1645053phenolics
phis95724903ph__i_s
phocine1438833phocine
phoebes1435813phoebes
phoebus1443823phoebus
phonemics1844933phonemics
phones114121213pho_nes
phonetics1646733phonetics
phoneys15437143phoneys
phonied133710563phonied
phonier122710633phonier
phoniest132811543phoniest
phonily1537103phonily
phoning13312053phoning
phonons123310253phonons
phonos114114793pho_nos
phons105221143pho__ns
photogs13358213photogs
photonics1649353photonics
photons123814433photons
photos113316643pho_tos
phots105418503pho__ts
phylic16279553phylic_
physic16288473physic_
physis14359663physi_s
phytins15317893phytins
picnics13297343picnics
pics85633913p___ics
pionic103515953pionic_
poboys1397313p_oboys
poetics11312073poetics
pogies94123543p_ogies
pois66539043p_o_i_s
pokies125921333p_okies
police102918563p_olice
polices113118053p_olices
policy133211513p_olicy
polies84034583p_olies
polios84019723p_olios
polis74731163p_oli_s
ponies84833463p_onies
pooris83916843poori_s
posies84431433p_osies
posits85718713p_osits
prebids12399883prebids
probers113514583probers
probes104119453prob_es
probing123314443probing
probit103218353probi_t
probity14299683probity
profits122911243profits
proxies163014933proxies
psocids1234863psocids
ptosis83611823ptosi_s
ptotic102713373ptotic_
pubic114513723p_ubic_
pubis94616473p_ubi_s
publics13207143publics
pyknics1842483pyknics
pyosis114012123pyosi_s
rhodic12227233rhodic_
rhombic16264533rhombic_
rhotic112711233rhotic_
robins83617453_robins
shogis103810943shogi_s
shojis16348493shoji_s
sonics84315633_sonics
spherics1537073spherics
stoics8311113sto_ics
thorias102312053thorias
thoric114314043thoric_
tobies84521023_tobies
tonics83617863_tonics
topics104714583_topics
torics85118353_torics
toxics153910203_toxics
tropics113610653tropics
whosis1237173whosi_s

Search took 9 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.716249568.4
2DLD Change Limit1340271567.31318327.2
3Display Results1561560.0463391.3
 (SQL Overall)1786911568.07522128.9
 
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.