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

134 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
pities8382808(None) 
cities84524851cities
pieties9419221pieties
pitied94017251pitied
pitier84019821pitier
pitiers93812651pitiers
pixies154915511pixies
amities9317382amities
bikies124515162bikies
bites75641172bit_es
cites74435582cit_es
citied94014142citied
civies114116442civies
cuties84927362cuties
deities82621922deities
didies84621832didies
dirties83119382dirties
dites66339152dit_es
ditties83116982ditties
ditzes163212422ditzes
duties74921902duties
fifties132111082fifties
gites65630182git_es
ivies84215752_ivies
kilties113014142kilties
kites95432542kit_es
kithes135016652kithes
kitties113213622kitties
laities7320342laities
lilies63021412lilies
litres65220392litres
mites75141802mit_es
mitier83620662mitier
mitiest93520052mitiest
mitis75425982miti_s
mitises9315542mitises
mitres83922072mitres
nifties102612502nifties
nites55736342nit_es
nitres65519332nitres
nixies135313872nixies
panties94230932panties
paries84742512paries
parities10522972parities
parties93230862parties
pasties94529812pasties
pates76047892pat_es
patines95225762patines
patins87528782patins
patios85221782patios
patsies93919482patsies
patties93425142patties
petites93820202petites
pieces104217272pieces
pies66949602p__ies
piggies113813482piggies
pigmies122610992pigmies
pigsties1139782pigsties
pikes115031032pi_kes
pikis115116392piki_s
piles74742612pi_les
pilis75825202pili_s
pines76048862pi_nes
pinier84024692pinier
piniest93121132piniest
pinites9319532pinites
pinkies133818262pinkies
pinnies93318442pinnies
pintles94118722pintles
pintoes95117712pintoes
pipes96030142pi_pes
pipier104913982pipier
pipiest113114492pipiest
pipits104713062pipits
piques1739092piques
pishes114722102pishes
pisses84525082pisses
pistes85325632pistes
pistils93314302pistils
pitas77427672pit_as
pitches143617752pitches
pithed124615612pithed
pithier123010292pithier
pithiest132711442pithiest
piths105817542pit_hs
pitiless10127332pitiless
pitmen102510792pitmen
pitons85319042pitons
pits66348742pit__s
pittas86014522pittas
pitted94319592pitted
pixes144323172pi_xes
pixie145415522pixie_
platies93722542platies
plies74526512p_lies
pogies94123542pogies
pokies125921332pokies
polies84034582polies
polities102722342polities
ponies84833462ponies
posies84431432posies
posties93128812posties
potpies113116172potpies
potsies93019482potsies
potties93723542potties
pries74339532p_ries
privies122414262privies
punties94520782punties
purities10316282purities
putties94420022putties
putzes174212522putzes
pyxies18338292pyxies
reties65436192reties
rites54442552rit_es
ritzes154812942ritzes
sites56045432sit_es
sixties14310972sixties
spites84127332spit_es
spitzes1849172spitzes
sties55132982_sties
tidies74721832tidies
ties45248312__ties
tithes94720212tithes
titis56023812titi_s
titles63719922titles
titres64718932titres
titties73617362titties
unities72520142unities
unties64326922unties
whities133113252whities
wites85536962wit_es
withes124620842withes
withies133913542withies
zitis145815582ziti_s

Search took 4 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 Filter178691825510.1101624463.6
2DLD Change Limit825511342.93628116.8
3Display Results1341340.0304466.7
 (SQL Overall)1786911343.07658092.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.