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

158 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
ploidies113817(None) 
bloodies11310162bloodies
diploidies1463832diploidies
euploidies1353112euploidies
haploidies1643192haploidies
plotties103111412plotties
policies122415662policies
polities102722342polities
accidies1338033accidies
alibies9313323al_ibies
blondes104213163blond_es
blondines1246153blondines
bloodied1245973bloodied
bloodier1136823bloodier
bloodiest1236663bloodiest
bodies94524143_bo_dies
bolides10515073bolid_es
boodies103721443_boodies
cloddier1234063cloddier
cloddiest1334633cloddiest
clonidines1374553clonidines
cloudier1135053cloudier
cloudiest1235583cloudiest
crowdies1437543crowdies
didies84621833__didies
doilies84017363_doilies
doodies94218773_doodies
dowdies123412733_dowdies
elides74420693el_id_es
floosies113210233floosies
floozies20326953floozies
floppies1546813floppies
flossies112810123flossies
fluidics1442923fluidics
fluidise1254543fluidise
fluidises1354383fluidises
fluidizes2243813fluidizes
foodies113416753_foodies
glides84518863gl_id_es
glories81915913glo_ries
glorifies1346363glorifies
glossies93311253glossies
goodies93516993_goodies
hoodies113419833_hoodies
howdies142911953_howdies
klondikes1341473klondikes
laddies93715053_laddies
ladies75124883_l_adies
laities7320343_laities
lilies63021413_l_ilies
lindies8416583_lindies
lobbies113612463_lobbies
lodes66436913_lo_d_es
lodges86820143_lo_dges
loided83414023_loid_ed
loiding93313403_loiding
loids66220703_loid__s
lollies73116923_lollies
longies82916553_longies
loobies93814103_loobies
looies65025833_lo_oies
loonies73919543_loonies
lories64933043_lo_ries
lorries74518343_lorries
louies64525103_lo_uies
melodies11310123melo_dies
noddies93512043_noddies
oldies7314423__oldies
ologies8615023olo_gies
oroides8311973oroid_es
pacifies15311223pacifies
paddies113715723p_addies
pandies104224503p_andies
parities10522973parities
parodies11313693parodies
peonies93620153peo_nies
perfidies1546603perfidies
phonies123717513pho_nies
pilosities1247793pilosities
piosities11311713piosities
pities83828083p__ities
pixies154915513p__ixies
plaices11411143plai_ces
plaided11409643plaid_ed
plaids94312443plaid__s
platies93722543pl_aties
plaudits1144263plaudits
pledges113811563pl_edges
pleiades1145753pleiades
plenties10314693plenties
plies74526513pl___ies
pliskies1475973pliskies
plisses94411773pl_isses
plodded1265563plo_dded
plodder1146003plo_dder
plodders1235523plodders
plodding13166343plodding
plods85719293plo_d__s
ploidy1237483ploid__y
plosives1335893plosives
plotlines1146823plotlines
plottier10327263plottier
plottiest11287833plottiest
plotzes18317693plo_tzes
podites103014733p_odites
poesies93217403p_oesies
pogies94123543p_o_gies
pointes93216753p_ointes
poises84226543p_oi_ses
pokies125921333p_o_kies
polices113118053poli_ces
polies84034583p_o_lies
polishes13711783polishes
politics122513813politics
pommies133712843p_ommies
ponies84833463p_o_nies
poodles103013513p_oodles
poppies102816193p_oppies
popsies112816463p_opsies
porgies103017003p_orgies
porkies133416493p_orkies
posies84431433p_o_sies
posties93128813p_osties
potpies113116173p_otpies
potsies93019483p_otsies
potties93723543p_otties
prairies10411453prairies
prides94324183p_rid_es
priories10312453priories
privies122414263p_rivies
probities13312653probities
prodigies1346953prodigies
prosodies1249723prosodies
prossies101515223prossies
prosties101421193prosties
provides1439883provid_es
proxies163014933pro_xies
purifies13311923purifies
purities10316283purities
pyridines1546473pyridines
pyxides2034423pyxid_es
roadies83317433_roadies
rowdies113112693_rowdies
shoddies1336043shoddies
slides73922183sl_id_es
sloids73712693sloid__s
soddies92312853_soddies
splodges1234153splo_dges
tidies74721833__tidies
toadies82914853_toadies
toddies93011993_toddies
todies74223553_to_dies
tolidines1046883tolidines
tolidins948023tolidins
triploidies1452593triploidies
untidies939813untidies
woodies113517153_woodies
zloties1639913zlo_ties

Search took 8 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 Limit1461621587.61019206.6
3Display Results1581580.0632507.9
 (SQL Overall)1786911587.82922824.2
 
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.