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

358 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
poetise931404(None) 
poetised1138521poetised
poetiser1037311poetiser
poetises10313951poetises
poetize18310771poetize
betise85616272_betise
monetise10311472monetise
mortise9713532mortise
peise75825772p_e_ise
petite84320652p_etite
pieties9419222pieties
pietism1139112pietism
pietist9414032pietist
poesies93217402poesies
poetess938932poetess
poetic10416842poeti_c
poetics11312072poetics
poetisers1145302poetisers
poetized2037972poetized
poetizer1936812poetizer
poetizes19310252poetizes
poetlike1436732poetlike
poetries10315582poetries
poets76024442poet_s_
poise75127892po__ise
pontine92419052pontine
postie84123962posti_e
posties93128812posties
potsie83916022po_tsie
potties93723542potties
poutine93316822poutine
precise113518172precise
premise113818552premise
previse123713792previse
acetose938843acetose
amortise10428513amortise
appetiser1344443appetiser
appetite1258493appetite
azotise1637073azotise
baptise1139553baptise
betide95115973_betide
betime105914833_betime
betises94816123_betises
bootie85421153booti_e
booties94124613booties
cerise84822043_cerise
chemise143211503chemise
coatis85122593coatis_
coesite9713623coesite
coexist1638583coexist
cognise1059683cognise
coltish121310933coltish
concise11314473concise
contuse9311413contuse
cootie84223073cooti_e
cooties93725733cooties
costive12312843costive
demise94618323_demise
devise104215753_devise
doltish11118733doltish
elegise8139393elegise
emetine9712943emetine
fetish12310373_fetish
foetid10510513foeti_d
foetus958523foetus_
foetuses1136083foetuses
footie94718133footi_e
footies103721543footies
footsie1047643footsie
foretime1348213foretime
forties104323863forties
fortis95418613fortis_
goatish1139563goatish
goethite1244053goethite
hoelike141411163hoelike
hogtie102711763hogti_e
hogties112813993hogties
hoise85224773ho__ise
hostile10312553hostile
hottie92514363hotti_e
hotties103016953hotties
hottish13117893hottish
iodise74214933io_dise
ionise63516933io_nise
itemise997453itemise
ketose105711813_ketose
loutish1039963loutish
metis75025903_metis_
metisse936503_metisse
moieties10311263moieties
monetised1246973monetised
monetises11311043monetises
monetize1949983monetize
mortice11711493mortice
mortised1178743mortised
mortiser1078473mortiser
mortises10713603mortises
motile83818343mo_tile
motive113112143mo_tive
noesis6311443noesis_
noesises838503noesises
noetic8514043noeti_c
noise55723733no__ise
notice8313443no_tice
novelise1137953novelise
nowise9511073no_wise
obelise9310173obelise
obtuse8147483_obtuse
onetime937623onetime
operose939433operose
optime1079343_optime
otiose639403_o_tiose
paise75028333p__aise
palewise1346423palewise
palletise11127633palletise
pantie84326473panti_e
panties94230933panties
pantile93918483pantile
parties93230863parties
partite9317133partite
parvise124211693parvise
pastie85525523pasti_e
pasties94529813pasties
pastime114611973pastime
pastis84924323pastis_
pastises103616053pastises
patine85328123p_atine
pattie84020963patti_e
patties93425143patties
pavise114714803p_avise
pease75231113p_e_ase
pectase112410363pectase
pectize20259913pectize
peerie83617893peeri_e
peeries93623023peeries
peevish1535783peevish
peised94817683p_e_ised
peises84125043p_e_ises
pelisse967063p_elisse
pelite84323003p_elite
pelletise1146663pelletise
penile82219603p_enile
penis75129323p_enis_
penises9318193p_enises
pentose9311593pentose
peonies93620153peonies
peonism11611103peonism
peptide122910683peptide
peptize20279483peptize
peris75537073p_eris_
perish114619063p_erish
perse75429523p_e_rse
peruse84016843p_eruse
petiole9311303p_etiole
petit74332653p_eti_t
petites93820203p_etites
pets66248333p_et_s_
pettish1238283pettish
pettle84116053p_ettle
phonetist1448813phonetist
pietas84516503pietas_
pietisms1247463pietisms
pietists1038323pietists
pities83828083p_ities
platies93722543platies
please84315733ple_ase
plenish1239943plenish
plenism11310113plenism
plenist9314333plenist
plenties10314693plenties
plotties103111413plotties
podite93315353po_dite
podites103014733podites
podlike14108553podlike
poems95715553poe_ms_
poesy105014063poe__sy
poet65552903poet___
poetaster1145673poetaster
poetesses1137233poetesses
poetical12311533poetical
poeticism1548333poeticism
poeticize2247513poeticize
poetising1238713poetising
poetizers2045103poetizers
poetless1038723poetless
poetry1139383poet_ry
pogies94123543po_gies
pois66539043po__is_
poised94918473po__ised
poiser84217243po__iser
poises84226543po__ises
pokies125921333po_kies
polarise10513903polarise
poleis86018353poleis_
polemist12412363polemist
polemize2148673polemize
police102918563po_lice
polies84034583po_lies
polis74731163po_lis_
polish114916723po_lish
polite83625073po_lite
polities102722343polities
pollist9816603pollist
poloist91016323poloist
pommie123710503pommi_e
pommies133712843pommies
ponies84833463po_nies
pontes83627853pontes_
pontifex2043253pontifex
pontiff1547903pontiff
pontil8315463ponti_l
pontils9312213pontils
pooris83916843pooris_
poorish123712303poorish
popelike16177853popelike
poperies12316793poperies
popish133812113po_pish
poppies102816193poppies
popsie103013053popsi_e
popsies112816463popsies
porcine11312843porcine
porgies103017003porgies
porism104518063po_rism
porkies133416493porkies
porose84818743po_rose
porpoise1248073porpoise
portage103013643portage
portico11310143portico
portiere1038773portiere
porting103021783porting
portion9615493portion
ports75934593port_s_
portside1138163portside
pose66441733po___se
posies84431433po_sies
positive1349993positive
posits85718713posits_
posse74722273po__sse
postage103214853postage
postbase1246443postbase
postdive1445763postdive
postfire1346273postfire
postiche1547793postiche
postin83521033posti_n
posting105622243posting
postins93721203postins
postique1945873postique
postpose1247643postpose
posts75228783post_s_
posture9313253posture
potage92715903po_tage
potash1138273po_tash
potence11711363potence
potiche1438043po_tiche
potion84519573po_tion
potlike13910123potlike
potline91015233potline
potpie103412423po_tpie
potpies113116173potpies
pots66452363po_t_s_
potsies93019483po_tsies
potsy105815613po_t_sy
pottage103310603pottage
pottier93516493pottier
pottiest102815973pottiest
potting103720893potting
pottle84416103po_ttle
pottles93816983pottles
pottos84615873pottos_
poultice1246063poultice
poussie936623poussie
poutier93215323poutier
poutiest103016793poutiest
poutines102415103poutines
pouting103519943pouting
pouts75530323pout_s_
poverties1439513poverties
practise12310143practise
praise84419413p_raise
precipe133012123precipe
precis103416703precis_
precised133213413precised
preciser123411663preciser
precises123218333precises
predive13511083predive
prefile123413183prefile
prefire124012813prefire
prelife1279943prelife
premie103617993premi_e
premies113823063premies
premised133013193premised
premises123018273premises
premiss113513813premiss
prentice121012353prentice
prerinse1038633prerinse
prese75228383pre__se
preside10715613preside
prestige11310733prestige
pretape113511623pretape
pretaste10139523pretaste
pretense10199813pretense
pretest9517633pretest
pretties10615133pretties
pretype14387483pretype
prevised143611073prevised
previses133814283previses
prewire124311133prewire
prexies163415003prexies
prise74632613p__rise
proette9312363proet_te
proettes10312763proettes
promise113415843promise
prostie91617743prosti_e
prosties101421193prosties
protease10209893protease
proteide11239723proteide
proteose10229413proteose
protist9320223protist
puerile9310093puerile
punties94520783punties
puttie84116303putti_e
putties94420023putties
remise84221953_remise
rerise64325633_rerise
retie55735303_reti_e
reties65436193_reties
retile65929673_retile
retime85321803_retime
retine66237333_retine
retire64927013_retire
retuse66617223_retuse
revise94019743_revise
rotis56327053ro_tis_
routine72615903routine
seise54727853_se_ise
setose65114773_setose
softie93312473softi_e
softies103414613softies
softish13127813softish
solecise1089073solecise
sometime1246743sometime
somewise1345553somewise
sortie63621983sorti_e
sorties74126403sorties
sottish10129433sottish
soubise9118793soubise
speise84614253spe_ise
sportive1348333sportive
toelike11149823toelike
tontine72316143tontine
tootsie737123tootsie
tortile7313193tortile
tortoise847093tortoise
treatise8311103treatise
tsetse664693tset_se
votive12348933vo_tive
yetis85418393_yetis_
zonetime1944953zonetime

Search took 7 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.1561145455.1
2DLD Change Limit1340273586.11021935.7
3Display Results3583580.1232910.6
 (SQL Overall)1786913586.38927968.5
 
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.