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

152 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
phobias1422818(None) 
phobia13278601phobia_
phobics16286701phobics
aphonias132611142aphonias
cobias104014992_cobias
dhobis1236112dhobi_s
obias76116862__obias
phobic153010072phobi_c
phonics143110722phonics
phonies123717512phonies
photics142810482photics
probits112712572probits
thorias102312052thorias
acholias1349573acholias
anopias92412483anopias
anoxias14259113anoxias
aphagias14237353aphagias
aphasias132710443aphasias
aphonia122711883aphonia_
aphonics15259523aphonics
aporias9315153aporias
atonias73315993atonias
bias64738163___bias
boobies113718203boobies
chias104625523ch__ias
choirs114911883cho_irs
cholas114818003cho_las
chollas123811353chollas
chopins142312243chopins
choreas124414203choreas
chorial124214143chorial
cobia94117513_cobia_
cobras104014193_cobras
cumbias13338963cumbias
dhobi1136973dhobi__
dhooras1135943dhooras
dhotis1038973dhoti_s
dobies94422093_dobies
doblas93812293_doblas
dobras94811913_dobras
doobies103915673doobies
euphorbias17102393euphorbias
euphorias1466283euphorias
gambias125010733gambias
globins10278953globins
glorias81610323glorias
gobies95418063_gobies
habits113014653_habits
hobbies143813343_hobbies
hobbits14317553_hobbits
hoboes114717453_hoboes
hobos106321353_hob_os
hobs97038983_hob__s
holies94630033_holies
hollas94616903_hollas
homies114524733_homies
hondas10313353_hondas
hookas135312503_hookas
horas86333103_ho_ras
hostas94515833_hostas
hoyas115016163_ho_yas
loobies93814103loobies
mahonias1348063mahonias
misbias1139083misbias
myopias14308153myopias
norias65518203_norias
nubias8310093_nubias
obas65730933__ob_as
obia67923113__obia_
obis66226843__obi_s
obits74617553__obits
ohias84415573__ohias
pelorias10410593pelorias
pembinas1454143pembinas
peonies93620153peonies
phasis114614923phasi_s
phial10313203ph__ial
phials1158873ph__ials
phis95724903ph__i_s
phocine1438833phocine
phoebes1435813phoebes
phoebus1443823phoebus
phonal11310383pho_nal
phones114121213pho_nes
phoneys15437143phoneys
phonic133315213phoni_c
phonied133710563phonied
phonier122710633phonier
phoniest132811543phoniest
phonily1537103phonily
phoning13312053phoning
phonons123310253phonons
phonos114114793pho_nos
phons105221143pho__ns
photic133316443photi_c
photogs13358213photogs
photons123814433photons
photopias16410143photopias
photos113316643pho_tos
phots105418503pho__ts
physics17265963physics
physis14359663physi_s
phytins15317893phytins
pias66542553p___ias
poboys1397313p_oboys
podia8415283p_odia_
pogies94123543p_ogies
pogonias1148513pogonias
pois66539043p_o_i_s
pokies125921333p_okies
polies84034583p_olies
polios84019723p_olios
polis74731163p_oli_s
polkas1239103p_olkas
ponies84833463p_onies
pooris83916843poori_s
poppas93710713p_oppas
posies84431433p_osies
posits85718713p_osits
prebids12399883prebids
proas75028803pro__as
probers113514583probers
probes104119453prob_es
probing123314443probing
probit103218353probi_t
probity14299683probity
profits122911243profits
proteas92015123proteas
proxies163014933proxies
psoas75012983pso__as
psocids1234863psocids
ptosis83611823ptosi_s
pubis94616473p_ubi_s
pyemias1436803pyemias
pyosis114012123pyosi_s
pyurias1236713pyurias
robins83617453_robins
scotias939753scotias
sharias102516003sharias
shogis103810943shogi_s
shojis16348493shoji_s
shortias1148093shortias
sobas74424253_sob_as
terbias9310743terbias
thoria93012893thoria_
thulias1035743thulias
tibias839953_tibias
tobies84521023_tobies
urbias839093_urbias
utopias9117723utopias
whosis1237173whosi_s
zoophobias2653453zoophobias

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.406440125.6
2DLD Change Limit1340271526.61020276.4
3Display Results1521520.0632412.7
 (SQL Overall)1786911527.07925242.4
 
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.