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

122 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
pipeage123620(None) 
pipage1199141pip_age
pipeages1336421pipeages
lineage878982lineage
mileage10299312mileage
peage84723572__peage
pileate93815922pileate
pillage103412602pillage
pipages1289422pip_ages
pipette1137942pipette
acreage1037843acreage
amperage1347743amperage
appease1137913appease
biplane1139033biplane
diphase1387273diphase
disease83213843disease
diverge12347643diverge
ideate7313683_ideate
image81411293_i_mage
incage93513623_incage
innage73011573_innage
liege65314433li_e_ge
limeade1076123limeade
linage7713403li_nage
lineages979183lineages
lineate7815153lineate
linkage1295963linkage
lipase8239103lip_ase
milage93414123mi_lage
mileages11249693mileages
millage103112753millage
mintage101110123mintage
mirage92313653mi_rage
misease92713043misease
mispage12310523mispage
package16128013package
page76036103__p_age
paleae84820293palea_e
paleate94120003paleate
passage1039803passage
pawnage1335873pawnage
peace95026083__peace
peag75431343__peag_
peages94321853__peages
peags86122843__peags
pease75231113__pease
peerage1089803peerage
pelage9515363p_elage
peonage1048723peonage
phage115113673__phage
pickaxe2244623pickaxe
picrate112014143picrate
piece96717993pi_e_ce
pierce104010393pi_erce
pikake11115803pi_kake
pilea75123953pilea__
pileated112711133pileated
pilferage1542603pilferage
pillaged12298093pillaged
pillager11278553pillager
pillages113012613pillages
pilotage1145373pilotage
pineal84817693pinea_l
pineals93212853pineals
pinene82915653pine_ne
pinnace113510313pinnace
pinnae84414643pinna_e
pinnate93613743pinnate
pinwale1257843pinwale
pipal95118353pip_a_l
pipals104213643pip_als
pipe86434443pip___e
piped105123163pipe__d
pipeful1445643pipeful
pipelike16166693pipelike
pipeline12149503pipeline
piper96523193pipe__r
piperine122011833piperine
pipers104318663pipe_rs
pipes96030143pipe__s
pipestem1443743pipestem
pipet95533323pipe__t
pipets105714773pipe_ts
pipetted1335263pipetted
pipettes1237563pipettes
piping114017453piping_
pipings12338253pipings
pirate82322883pi_rate
pishoge1336693pishoge
plage84520403__plage
please84315733p_lease
pledge10469493p_ledge
plumage1245503plumage
poleaxe1656303poleaxe
portage103013643portage
postage103214853postage
potage92715903p_otage
pottage103310603pottage
preaged11612333p_reaged
prepare111913623prepare
prepave14228873prepave
presage10312293presage
primage12169143primage
prophage1649433prophage
pupae96515643pup_a_e
pupate104213123pup_ate
pupilage1343773pupilage
rivage1038843ri_vage
seepage1037543seepage
septage1078403septage
siege66718443si_e_ge
signage937773signage
silage72715303si_lage
sinkage1287263sinkage
slippage13103943slippage
spillage1146263spillage
spinage10289653spi_nage
tillage83111343tillage
village113610833village
vintage11128143vintage
visage1049083vi_sage
windage1237933windage

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 Filter1786911340270.420425454.8
2DLD Change Limit1340271226.67320085.0
3Display Results1221220.0462652.2
 (SQL Overall)1786911227.13925030.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.