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

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

257 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
phis9572490(None) 
ahis76135381ahis
aphis105917131aphis
chis95933311chis
ghis85020161ghis
his66359501_his
khis117017981khis
phi86524201phi_
phiz186718841phiz
pis56362031p_is
pois66539041pois
psis68120341psis
this76027381this
ahi68040232ahi_
ahs68644822ah_s
ais39083572_ais
amis66445322amis
anis45746462anis
aphid115515392aphid
aphids125110842aphids
apsis75718292apsis
axis116127912axis
bis56860662_bis
bris65539612bris
chais107530312chais
chi86228652chi_
chia96026622chia
chias104625522chias
chic115925202chic
chics123920942chics
chid106626402chid
chin96934742chin
chins105631462chins
chip116726422chip
chips125721252chips
chit96937462chit
chits105424572chits
cis57748032_cis
cris66233432cris
dais57040702dais
dis46459892_dis
egis56520652egis
ephas10311542ephas
ghi77019882ghi_
has67372652_has
hes66654202_hes
hi57947582_hi_
hic86540562_hic
hid76248382_hid
hie67652702_hie
hies74842832_hies
him86247662_him
hims95230972_hims
hin67559562_hin
hins76447992_hins
hip86750432_hip
hips96433702_hips
hisn79620932_hisn
hiss75629212_hiss
hist76551542_hist
hit66569192_hit
hits75545132_hits
hos68364192_hos
ibis66519582ibis
iris45732552iris
is27048212__is
iwis77117012iwis
khi106318302khi_
kis78051482_kis
kois85129402kois
kris86423602kris
leis45739602leis
lis37162272_lis
mhos95517772mhos
mis58162622_mis
obis66226842obis
ohia75719362ohia
ohias84415572ohias
ohms95514032ohms
ohs66232312oh_s
pacs85842182pacs
padis86227142padis
pads76742952pads
paid75737482paid
paik105726802paik
paiks114719852paiks
pail66141832pail
pails75833062pails
pain65647242pain
pains75138282pains
pair66031512pair
pairs75325832pairs
paisa76021072paisa
paise75028332paise
pals66951352pals
pams85641762pams
pans65855732pans
paps86443452paps
paris75145942paris
pars67560792pars
pas58775742p_as
pass65239952pass
pats66460852pats
pavis106422732pavis
paws96038182paws
pays95940222pays
peas65755062peas
pecs84634102pecs
peds75835242peds
pees65257372pees
pegs75531762pegs
pehs95625762pehs
pein65834942pein
peins76128062peins
peise75825772peise
penis75129322penis
pens65649642pens
peps85134512peps
peris75537072peris
pes57259782p_es
pets66248332pets
pews95731532pews
phase104617212phase
phasis114614922phasis
phat95837862phat
phew128417112phew
phial10313202phial
phials1158872phials
phizes20389132phizes
phon95925382phon
phons105221142phons
phot95534362phot
phots105418502phots
pht86030522ph_t
phut96925972phut
phuts104613502phuts
physis14359662physis
pi48145362p_i_
pia56848032p_ia
pias66542552pias
pic76046822p_ic
pics85633912pics
pie55457402p_ie
pies66949602pies
pig65744972p_ig
pigs76634222pigs
pikis115116392pikis
pilis75825202pilis
pin57066722p_in
pins65558452pins
pip78051042p_ip
pips85837132pips
pish96127912p_ish
piso66727562p_iso
piss65033332piss
pit56471922p_it
pits66348742pits
piu56639542p_iu
pix126437932p_ix
plie65127392plie
plies74526512plies
plus66324832plus
pods76540152pods
poi57244662poi_
poise75127892poise
polis74731162polis
pols66044562pols
poms87037742poms
pons65850602pons
poos65949112poos
pops86340952pops
pots66452362pots
pows95537662pows
pries74339532pries
prig75924872prig
prigs85219702prigs
prim85132202prim
prims95425932prims
prise74632612prise
prism94820262prism
priss74623892priss
pros65742782pros
psi56621622psi_
pubis94616472pubis
pubs85029212pubs
puds75630512puds
pugs76332772pugs
pulis74225602pulis
puls65437562puls
puns66641482puns
pups86032232pups
puris75332022puris
purs65641042purs
pus55547842p_us
puss64830132puss
puts65641752puts
pyas96225702pyas
pyes95528992pyes
pyic116915822pyic
pyin96823232pyin
pyins105815862pyins
pyxis17458632pyxis
qis126934382_qis
rais45252622rais
raphis114014322raphis
reis45343232reis
rhos76319062rhos
rhus75114052rhus
seis45542392seis
shes75734352shes
shies86136552shies
shim95827862shim
shims104422552shims
shin75634312shin
shins85131042shins
ship95228242ship
ships105123772ships
shist84829612shist
shit76745942shit
shits84731172shits
shiv105721172shiv
shivs115018802shivs
shris84221452shris
sis37360542_sis
skis84825292skis
spahis11310382spahis
sris45434152sris
thin76732392thin
thins85826332thins
thio77225412thio
thir76420542thir
thus76721472thus
tis37056642_tis
tuis44829642tuis
vis66747612_vis
whid115418872whid
whids125413982whids
whig115516422whig
whigs125612642whigs
whim126220532whim
whims134515332whims
whin105225692whin
whins114922332whins
whip125521842whip
whips134917082whips
whir105519282whir
whirs115218092whirs
whish144512922whish
whisk154510142whisk
whist115322952whist
whit104834172whit
whits115923822whits
whiz195919942whiz
whys137011662whys
wis66552332_wis
xis106935332_xis
ywis105313102ywis

Search took 2 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 Filter178691298720.500357382.0
2DLD Change Limit298722571.11026911.7
3Display Results2572570.0604283.3
 (SQL Overall)1786912571.670107000.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.