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

66 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
pilotage114537(None) 
pilotages1245501pilotages
flotage1136682_flotage
helotage1245712helotage
pillage103412602pil_lage
plottage1144432p_lottage
potage92715902p__otage
agiotage1043563agiotage
bilobate1247033bilobate
cabotage1345223cabotage
dilatate947773dilatate
dotage82711613__dotage
ecotage1036883_ecotage
floatage1244403_floatage
flotages1237163_flotages
flowage1435723_flowage
footage1148843_footage
helotages1346123helotages
kilobase1453873kilobase
lovage1037353__lovage
meltage1037953mel_tage
milage93414123mil__age
mileage10299313mil_eage
militate10311673militate
millage103112753mil_lage
mintage101110123mi_ntage
pelage9515363pel__age
pelota8612833pelota__
pelotas9410723pelota_s
peltate92013773pel_tate
peonage1048723p_eonage
picotee11311473picot_ee
picowave18102793picowave
pileate93815923pil_eate
pilferage1542603pilferage
pillaged12298093pil_laged
pillager11278553pil_lager
pillages113012613pil_lages
pilose84514243pilo__se
pilot77435063pilot___
piloted10310323pilot_ed
piloting1139693piloting
pilotings1234353pilotings
pilots84018873pilot__s
pipage1199143pi__page
pipeage1236203pi_peage
pivotable1644563pivotable
pivotal1245433pivota_l
plage84520403p_l__age
platane93112303p_latane
plottages1244243p_lottages
plumage1245503p_lumage
portage103013643p_ortage
postage103214853p_ostage
potages102416423p__otages
pottage103310603p_ottage
protege1059153p_rotege
rootage839053_rootage
sabotage1144603sabotage
silage72715303sil__age
siloxane1543743siloxane
spillage1146263spil_lage
tillage83111343til_lage
village113610833vil_lage
vintage11128143vi_ntage
voltage1136863vol_tage

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.406440125.6
2DLD Change Limit146162667.12320519.7
3Display Results66660.0332000.0
 (SQL Overall)178691667.56223630.1
 
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.