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 “piefort” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

84 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
piefort124953(None) 
piedfort1444871piedfort
pieforts1344861pieforts
piedforts1542482piedforts
pierrot948832pierrot
pilewort1389132pilewort
preform1439612preform
presort95219542presort
airport9511383airport
before11410153_before
biform1368123bi_form
bigfoot1355993bigfoot
bistort91216523bistort
comfort143611693comfort
deform1259623_deform
dehort104618103_dehort
deiform1336693deiform
deport94922393_deport
disport101015953disport
distort81120333distort
effort1238623_effort
figwort1448223figwort
finfoot1347173finfoot
fort76456443___fort
import102713763_import
inform11310153_inform
intort6418923_intort
liefer9529573liefer_
liefest1038443liefest
misform1437513misform
missort9314653missort
peart76440753p_e_art
perform1439283perform
pert66759323p_e__rt
piciform1764993piciform
picot95031013pi_co_t
piecer105213083piecer_
piecers114112253piecers
piedmont1345273piedmont
piehole12188553piehole
pier66035293pie__r_
pierogi1054723pierogi
pierrots1044963pierrots
piers75926333pie__rs
pietist9414033pietist
pigboat1247823pigboat
pignora10306363pignora
pigout9314613pi_gout
pileworts1495353pileworts
pilfer1139163pilfer_
pilfers1238963pilfers
piliform1555473piliform
pillory12247453pillory
pilot77435063pi_lo_t
pinafore1344513pinafore
pinfold1336233pinfold
pinot78737293pi_no_t
pinwork16107243pinwork
pinworm1467183pinworm
piriform1555753piriform
pisiform1564963pisiform
pivot106523873pi_vo_t
plexor1535253plexor_
plexors1645423plexors
port66059633p___ort
prefect141011073prefect
prefer113813203prefer_
prefers123713333prefers
prefire124012813prefire
preformat1646363preformat
preforms1537403preforms
premolt11312073premolt
presorts105311683presorts
pretor8315753pretor_
pretors9316813pretors
prework164210913prework
preworn124711223preworn
purport1159393purport
reform11312713_reform
report85326023_report
resort65728623_resort
retort66831153_retort
ribwort1249003ribwort
sievert10613293sievert

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.403443402.0
2DLD Change Limit134027846.34621119.9
3Display Results84840.0302800.0
 (SQL Overall)178691846.77926359.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.