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

114 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
pipeages133642(None) 
pipages1289421pip_ages
pipeage1236201pipeage_
lineages979182lineages
mileages11249692mileages
peages94321842__peages
pillages113012602pillages
pipage1199142pip_age_
pipettes1237562pipettes
acreages1138363acreages
amperages1447673amperages
appeases1238663appeases
asperges11318093asperges
biplanes1238563biplanes
dipsades1246493dipsades
diseases92415813diseases
diverges13258313diverges
ideates8313723_ideates
images91411453_i_mages
incages103013883_incages
innages82911303_innages
lieges74113443li_e_ges
limeades11116643limeades
linages8813173li_nages
lineage878983lineage_
linkages1385953linkages
lipases9209483lip_ases
milages103114403mi_lages
mileage10299313mileage_
millages113212893millages
mintages111110513mintages
mirages102213533mi_rages
miseases102614343miseases
mispages13311183mispages
packages17138733packages
pages85235073__p_ages
passages1139513passages
pawnages1435313pawnages
peaces106324083__peaces
peage84723563__peage_
peags86122843__peag_s
peases85229473__peases
peerages1189883peerages
pelages10714613p_elages
peonages1138473peonages
phages125213513__phages
pickaxes2344913pickaxes
picrates122013203picrates
pieces104217273pi_e_ces
pierces113411193pi_erces
pieties9419223pi_eties
pikakes1245823pi_kakes
pileate93815923pileate_
pileated112711133pileated
pilferages1642623pilferages
pillage103412593pillage_
pillaged12298083pillaged
pillager11278543pillager
pillagers12276903pillagers
pilotages1245503pilotages
pineals93212843pinea_ls
pinenes93416673pine_nes
pineries102419083pineries
pinnaces12268863pinnaces
pinwales1367963pinwales
pipals104213643pip_a_ls
pipefuls1543753pipefuls
pipeless12107663pipeless
pipelines13178333pipelines
piperines131610673piperines
pipers104318663pipe__rs
pipes96030143pip___es
pipestem1443743pipestem
pipestems1542833pipestems
pipets105714773pipe__ts
pipette1137943pipette_
pipetted1335263pipetted
pipings12338253piping_s
pirates93020323pi_rates
pishoges1446953pishoges
pizzazes1752513pizzazes
plages94520153__plages
pleases94515483p_leases
pledges113811563p_ledges
plumages1335653plumages
poleaxes1767273poleaxes
poperies12316793poperies
portages112613223portages
postages112815323postages
potages102416423p_otages
pottages112910453pottages
preaged11612333p_reaged
prepares122014163prepares
prepaves15189193prepaves
presages11312203presages
primages13159273primages
prophages1749763prophages
pupates113311433pup_ates
pupilages1443343pupilages
rivages1138873ri_vages
seepages1137283seepages
septages1168263septages
sieges73816833si_e_ges
signages1037473signages
silages82514443si_lages
sinkages1386853sinkages
slippages1483983slippages
spillages1256073spillages
spinages11289293spi_nages
tillages93011243tillages
villages123010593villages
vintages12118273vintages
visages1138693vi_sages
windages1338263windages

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 Limit1461621147.58019282.6
3Display Results1141140.0303800.0
 (SQL Overall)1786911147.76623009.4
 
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.