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

216 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
poussies103811(None) 
poussie936621poussie_
pussies93615691p_ussies
bossies94116832bo_ssies
gussies82813302_gussies
hussies103213292_hussies
mousses94012702mouss_es
plusses93510692pluss_es
poesies93217402po_esies
popsies112816462po_psies
posies84431432po__sies
posses85128802po_ss_es
posties93128812po_sties
potsies93019482po_tsies
prissies101712002prissies
prossies101515222prossies
pusses84322842p_uss_es
pussier93711992p_ussier
pussiest102911752p_ussiest
pusslies1036172p_usslies
wussies103411082_wussies
bolshies1338693bolshies
bosses85925403bo_ss_es
bossier93712423bo_ssier
bossiest103112213bo_ssiest
bougies103715183bou_gies
bounties10311393bounties
bourses94014303bours_es
boursins1037513boursins
bouses84931783bou_s_es
brassies103613533brassies
busbies113011693_busbies
busies85525263_bu_sies
busses85023383_buss_es
cissies94116153_cissies
cosies84932153co__sies
counties10316273counties
courses94218893cours_es
cousins9516003cou_sins
cusses84522773_cuss_es
dassies84418663_dassies
dosses76126273do_ss_es
dossier83711693do_ssier
dossiers9318043do_ssiers
dossils8669773do_ssils
douses74928933dou_s_es
flossies112810123flossies
focusses13155223focuss_es
footsies1139643footsies
fosses96022083fo_ss_es
fossils10379013fo_ssils
fusses94920553_fuss_es
fussier103610673_fussier
fussiest112910493_fussiest
gausses8308693gauss_es
glassies94012273glassies
glossies93311253glossies
gossips1035903go_ssips
gussie72910153_gussie_
gussied9267193_gussied
hissies103915823_hissies
hocusses13155303hocuss_es
hourlies1138343hourlies
houses96032273hou_s_es
housesits1244843housesits
huskies143212073_huskies
josses135117683jo_ss_es
jussives1833843_jussives
koumises1444593koumises
koussos11373903kouss_os
lassies74420103_lassies
loesses7310033loess_es
losses65925233lo_ss_es
louies64525103lou__ies
louses66230283lou_s_es
lousier72411623lou_sier
lousiest82311613lou_siest
missies93423983_missies
mosses85527683mo_ss_es
mossier94413813mo_ssier
mossiest103112443mo_ssiest
mouses85531423mou_s_es
mousier93712463mou_sier
mousiest102711763mou_siest
mousse84813033mouss_e_
moussed10338913mouss_ed
moussing1138143moussing
muskies133614663_muskies
musses84624783_muss_es
mussier93314353_mussier
mussiest103112933_mussiest
noesises838503noesises
nouses64627163nou_s_es
opuses84012243opu_s_es
outlies72421993_outlies
outsees72616433_outsees
outsides92513233_outsides
outsins73417863_outsins
outsits73215253_outsits
outsizes172311083_outsizes
outvies102214243_outvies
palsies94420273p_alsies
pansies94521983p_ansies
passes86030473p_ass_es
passives13228823p_assives
pasties94529813p_asties
patsies93919483p_atsies
pauses84621473pau_s_es
phoresies1447993phoresies
pigsties1139783pigsties
pisses84525083p_iss_es
pliskies1475973pliskies
plisses94411773pliss_es
pluses83618073plu_s_es
plushes124313673plu_shes
plushier1375193plushier
plushiest1466393plushiest
plussages1243293plussages
pocosins1258953pocosins
poetises10313953poetises
poetries10315583poetries
pogies94123543po__gies
poises84226543po_is_es
pokies125921333po__kies
policies122415663policies
polies84034583po__lies
polishes13711783polishes
polities102722343polities
pommies133712843po_mmies
ponies84833463po__nies
poolsides1254553poolsides
poperies12316793poperies
poppies102816193po_ppies
popsie103013053po_psie_
porgies103017003po_rgies
porkies133416493po_rkies
porkpies1636193porkpies
poses74642763po__s_es
posits85718713po__sits
posoles9314883po_soles
posse74722273po_ss_e_
possess9419113po_ssess
possesses1046313possesses
posset84923253po_ss_et
possets94212773po_ssets
possums1145753po_ssums
postie84123963po_stie_
postins93721203po_stins
potashes1337823potashes
potpies113116173po_tpies
potsie83916023po_tsie_
potties93723543po_tties
pouches144116743pou_ches
pouchier1546803pouchier
pouchiest1636843pouchiest
pouffes15408123pou_ffes
poultices1345673poultices
poultries1148453poultries
pounces114113893pou_nces
poussettes1243533poussettes
poutier93215323pou_tier
poutiest103016793pou_tiest
poutines102415103poutines
presses93523153press_es
prisses94816713priss_es
prissier10157873prissier
prissiest11178903prissiest
prosses94019513pross_es
prossie91812953prossie_
prosties101421193prosties
proustites1246453proustites
prussiates1244123prussiates
prussic1144743prussi_c
puisnes937423p_uisnes
pulses83818663p_uls_es
punkies134216803p_unkies
punties94520783p_unties
puppies103212613p_uppies
purses84826373p_urs_es
pursier94012753p_ursier
pursiest102812123p_ursiest
pursues94111373p_ursues
puses75532203p_u_s_es
pushes114621663p_u_shes
pushier123611093p_ushier
pushiest133211713p_ushiest
pussley12375123p_ussley
pussleys13273173p_ussleys
putties94420023p_utties
repousses1146063repouss_es
roughies1298323roughies
rouses65436283rou_s_es
sassies74719263_sassies
sissies73716603_sissies
soubises10107993soubises
souses64229243sou_s_es
sousliks1244003sousliks
spouses92912813spou_s_es
susses64221053_suss_es
tassies74918933_tassies
tootsies848613tootsies
tosses65225393to_ss_es
toughies1278243toughies
touses64229673tou_s_es
tousles74113933tou_sles
trusses73813633truss_es
trusties82712853trusties
tushies10312163_tushies
tusses64921243_tuss_es
tussis6379953_tussi_s
tussises835433_tussises
tussles737833_tussles
voussoirs1241593voussoirs
wusses93314893_wuss_es
wussier10408083_wussier
wussiest11268663_wussiest

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461622168.40617387.8
3Display Results2162160.0932322.6
 (SQL Overall)1786912168.65520646.0
 
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.