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

210 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
possum105795(None) 
opossum1153441opossum
possums1145751possums
dorsum947622dorsum
opossums1252382opossums
passim10410282passim
passus83610292passus
podium112911912podium
poseur8419402poseur
posse74722272poss_e
posses85128802posses
posset84923252posset
tossup875292tossup
alyssum1242473alyssum
assume897563_assume
blossom11114963blossom
boojum1733843boojum
bosom95516923bo_som
bosque17257733bosque
boss65938343boss__
bossdom1244243bossdom
bossed94816533bossed
bosses85925403bosses
bossism1136063bossism
bossy105515973boss_y
bosun75113593bo_sun
byssus1133763byssus
cesium1039583cesium
coassume12103973coassume
conium10415313conium
consul82312303consul
consume11510133consume
corium10315723corium
coss66143493coss__
cosset84125863cosset
costume1157853costume
crissum1144843crissum
doss56235043doss__
dossal75510303dossal
dossed84516633dossed
dossel74813643dossel
dosser74417973dosser
dosses76126273dosses
dossil75110903dossil
doum76226673do__um
folium11310453folium
forum108318763fo_rum
foss76431643foss__
fossa85812633foss_a
fossae95510373fossae
fossas94610703fossas
fosse86119463foss_e
fosses96022083fosses
fossil9379353fossil
gonium949803gonium
gossan747233gossan
gossip946433gossip
gypsum1442853gypsum
hassium1236133hassium
hokum1436773ho_kum
ionium8610923ionium
issue559213_issue
jorum145513743jo_rum
joss115925593joss__
josses135117683josses
koss85224813koss__
lissom837403lissom
locum94812173lo_cum
loss45337963loss__
losses65925233losses
lossy85214643loss_y
missus85312293missus
mosque17287163mosque
moss67641033moss__
mossed94818893mossed
mosser84618273mosser
mosses85527683mosses
mosso74715183moss_o
mossy105217063moss_y
museum1037703museum
nostrum946953nostrum
notum7611693no_tum
oakum1177313_oakum
odeum84610543_odeum
odium83413033_odium
oleum73613323_oleum
omasum1035503omasum
onium73115533_onium
opium92812093_opium
osmium1036573_osmium
ossa43714163_oss_a
ossia53710403_ossia
ostium8310133_ostium
ovum92310173_o_vum
pablum1237503pablum
pass65239953pass__
passe75525693pass_e
passed94320943passed
passee84522023passee
passel85117003passel
passer84721033passer
passes86030473passes
peplum12156823peplum
phylum1655153phylum
pileum10399513pileum
piss65033333piss__
pissed94816933pissed
pisser84416383pisser
pisses84525083pisses
plasm94114633plas_m
plenum1039503plenum
plum85122103p__lum
podiums12227633podiums
pods76540153pods__
podsol946853podsol
poem86225773po__em
poesy105014063poes_y
pogrom1138593pogrom
poilu72316003poilu_
poilus82210573poilus
pois66539043pois__
poise75127893pois_e
poised94918473poised
poiser84217243poiser
poises84226543poises
poisha1135723poisha
poison8312223poison
pols66044563pols__
pom78249913po___m
pomatum1346393pomatum
pompom1436493pompom
poms87037743poms__
pons65850603pons__
poos65949113poos__
popgun1145733popgun
pops86340953pops__
popsie103013053popsie
popsy125713403pops_y
porism104518063porism
porous84419483porous
posada937163posada
pose66441733po_s_e
posed85828413po_sed
poser75128773po_ser
posers84223973posers
poses74642763po_ses
poseurs9378293poseurs
posh95427323po_s_h
posher115018163posher
poshly1437723poshly
posies84431433posies
posing93922643posing
posit75833333po_sit
posits85718713posits
posole8314223posole
possess9419123possess
possets94212773possets
post67953363po_s_t
postal84317533postal
posted93722493posted
poster84129173poster
postie84123963postie
postin83521033postin
postop10511943postop
posts75228783po_sts
posture9313253posture
posy96028423po_s_y
potassium1352663potassium
potful1138083potful
pots66452363pots__
potsie83916033potsie
potsy105815613pots_y
pouf95732643po__uf
pour611527473po__ur
poussie936623poussie
pout65752553po__ut
pows95537663pows__
poyou102611523poyou_
poyous112911623poyous
presume11310303presume
prism94820263pris_m
pross76529403pross__
prosses94019513prosses
prossie91812953prossie
protium11312293protium
psalm949273p_salm
pseud867043p_seud
psst66118403p_ss_t
pursue84512253pursue
pushup1335273pushup
puss64830133puss__
pusses84322843pusses
pussly11407373pussly
pussy105614843puss_y
rostrum947213rostrum
scum85924523__scum
sensum849353sensum
slum65430513__slum
sodium92111453sodium
solum74717613so_lum
stum65526023__stum
sum56346013___sum
swum96416823__swum
tissue637333tissue
toss45637973toss__
tossed74215223tossed
tosser64215663tosser
tosses65225393tosses
tossups964023tossups
tussur6357293tussur

Search took 6 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 Filter1786911127160.390458182.1
2DLD Change Limit1127162105.51620434.4
3Display Results2102100.0633333.3
 (SQL Overall)1786912105.96929936.5
 
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.