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

63 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
pilotless114399(None) 
plotless10256791p_lotless
blotless10347152_blotless
hiltless11297122hil_tless
peltless10267372pel_tless
pileless1088622pil_eless
beltless10297713bel_tless
boltless10338283bol_tless
bootless103410983_bootless
colorless1145683colorless
filmless1344553fil_mless
footless113710803_footless
giftless1245173gi_ftless
guiltless1043023guil_tless
haltless11308443hal_tless
hitless103211193hi__tless
knotless1264573_knotless
lightless1386073lightless
limitless1142943limitless
lintless82710013li_ntless
listless8269263li_stless
loftless1135903__loftless
milkless1434773mil_kless
nightless1386073nightless
pastless102411203p_astless
picotees1247113picot_ees
pillarless1242543pillarless
pilotages1245503pilotages
piloted10310323pilot_e_d
pilotfish1742603pilotfish
pilotings1234353pilotings
pilots84018873pilot___s
pilules9510623pil_ule_s
pinocles1248693pinocle_s
pinoles93418713pino_le_s
pintles94118733pi_ntle_s
piolets93513193pi_o_lets
pipeless12107663pi_peless
pistoles102514723pistole_s
pithless13117023pi_thless
pitiless10127333pi_tiless
planless1036823p_lanless
playless1334863p_layless
pleatless1134613pleatless
plotters104011553p_lotters
plotzes18317703p_lotze_s
plugless1133863p_lugless
poetless1038723p_oetless
pointless1135713pointless
poleless1089873pol_eless
portless10310643p_ortless
printless1137523printless
pulpless12224953pul_pless
riftless1136943ri_ftless
rootless83910443_rootless
saltless8259343sal_tless
sightless1385923sightless
slitless8268143_slitless
spiritless1243743spiritless
spotless1037043_spotless
tintless8239863ti_ntless
visorless1243143visorless
witless103310983wi__tless

Search took 9 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 Filter1786911486410.420425454.8
2DLD Change Limit148641637.64319448.0
3Display Results63630.0302100.0
 (SQL Overall)178691638.09322079.7
 
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.