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

183 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
poise7512789(None) 
hoise85224771hoise
noise55723731noise
paise75028331paise
peise75825771peise
pois66539041pois_
poised94918471poised
poiser84217241poiser
poises84226541poises
pose66441731po_se
posse74722271posse
prise74632611prise
anise55129702anise
arise56436432arise
bise66437102_bise
boite74426322boite
bouse75931852bouse
bowse105420632bowse
copse95623922copse
corse75036182corse
cosie74728262cosie
dose56442432do_se
douse66329722douse
dowse96020812dowse
foist85730972foist
fosse86119462fosse
frise85322452frise
goose65925902goose
gorse65926812gorse
guise64717712guise
hoised105117432hoised
hoises94823672hoises
hoist86433212hoist
horse86132652horse
hose76547242ho_se
house89131422house
iodise74214942iodise
ionise63516942ionise
joist125125652joist
koine9516482koine
kois85129392kois_
loose56627682loose
lose45144582lo_se
louse56131012louse
lowse87219902lowse
mise66043582_mise
moire71017322moire
moist76033582moist
moose76327192moose
morse76032702morse
mouse77133002mouse
noised75416232noised
noises65021852noises
noisy86813362noisy
noose55624062noose
nose46739362no_se
nowise9511072nowise
opine77422462opine
ose38147342_o_se
owse76321622_owse
paisa76021072paisa
parse75236992parse
pase65346862p_ase
passe75525692passe
pause75021832pause
pavise114714802pavise
pease75231112pease
peised94817682peised
peises84125042peises
perse75429522perse
phase104617212phase
phis95724902phis_
pice84641092p_ice
pie55457402p_i_e
pies66949602p_ies
pike106335212p_ike
pile65649692p_ile
pine67755712p_ine
pipe86434432p_ipe
pis56362032p_is_
pish96127912p_ish
piso66727562p_iso
piss65033332p_iss
piste75824602p_iste
plie65127392pli_e
plies74526512plies
plisse8368402plisse
podite93315352podite
pods76540152pods_
poesy105014062poesy
poetise9314042poetise
pogies94123542pogies
poi57244662poi__
poilu72316002poilu
poind84217912poind
point75338732point
pointe84619312pointe
poisers94214432poisers
poisha1135722poisha
poison8312222poison
poke105335362po_ke
pokes116133012pokes
pokies125921332pokies
pole65951302po_le
poles75351002poles
police102918562police
polies84034582polies
polis74731162polis_
polish114916722polish
polite83625072polite
pols66044562pols_
pome85636692po_me
pomes94833932pomes
poms87037742poms_
ponce95222512ponce
pone65747532po_ne
pones74547042pones
ponies84833462ponies
pons65850602pons_
poos65949112poos_
poove104514302poove
pope85535612po_pe
popes95933812popes
popish133812112popish
pops86340952pops_
popsie103013052popsie
popsy125713402popsy
pore66451262po_re
pores75849032pores
porism104518062porism
porose84818742porose
posed85828412po_sed
poser75128772po_ser
poses74642762po_ses
posh95427322po_sh
posies84431432posies
posit75833332posit
posses85128802posses
posset84923252posset
post67953362po_st
posy96028422po_sy
pots66452362pots_
potsie83916022potsie
potsy105815612potsy
pows95537662pows_
poxes145325722poxes
praise84419412praise
prase76128752prase
prese75228382prese
price93725412price
pride84724732pride
pries74339532pries
prime96525602prime
prised94322202prised
prises84133172prises
prism94820262prism
priss74623892priss
prize164718942prize
promise113415842promise
prose75835122prose
psis68120342psis_
puisne856352puisne
pulse74219972pulse
purse76028892purse
raise54828052raise
rise45945232_rise
roose56127092roose
rose46148902ro_se
rouse56634702rouse
seise54727852seise
souse56530772souse
speise84614252speise
spouse84112512spouse
toile54626492toile
torse55833332torse
touse55430672touse
uprise82313692uprise
vise75632672_vise
voice104915322voice
voile84719722voile
wise75737342_wise
worse86525262worse
youse85322232youse

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 Filter178691538000.0961861364.6
2DLD Change Limit538001831.65332546.9
3Display Results1831830.0632904.8
 (SQL Overall)1786911831.81298615.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.