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

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

83 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
pannier9361335(None) 
cannier94014161cannier
panier84425501pa_nier
panner84224761pann_er
panniers10488851panniers
punnier93511261punnier
banner84421502bann_er
barnier93213672barnier
bonnier94711312bonnier
brannier10218932brannier
canner84625982cann_er
cannie83819362cannie_
dandier93714572dandier
fancier123412062fancier
fanner94218182fann_er
fannies103415642fannies
fawnier13296362fawnier
fennier10339252fennier
finnier10319952finnier
funnier103210172funnier
ginnier8298982ginnier
handier113817442handier
lankier113711632lankier
lanner64920602lann_er
mangier104114062mangier
manlier92414022manlier
manner84020512mann_er
nannie63713222nannie_
nannies73015202nannies
pacier105018682pa_cier
painter93814562painter
paintier1048792paintier
palier85023562pa_lier
pallier94417162pallier
palmier113312172palmier
pander93725522pa_nder
pandied113913442pandied
pandies104224502pandies
paniers94717332pa_niers
panne76623652pann_e_
panned94123432pann_ed
panners93621272pann_ers
pannes85522852pann_es
panniered1243852panniered
panning104019392panning
pansies94521982pansies
panther12611442panther
pantie84326472pantie_
panties94230932panties
panzer174213232pa_nzer
pappier103511592pappier
parrier93717652parrier
partier93520712partier
pastier94320382pastier
pawkier16236612pawkier
pawner114212922pawn_er
penner84616662penn_er
pennies94218812pennies
phonier122710632phonier
pinier84024692p_inier
pinner84521502pinn_er
pinnies93318442pinnies
planner93511622plann_er
pornier93413132pornier
punier84519222p_unier
punkier133512792punkier
punner84918152punn_er
rainier71614262rainier
randier83618472randier
rangier83714352rangier
runnier74010112runnier
sandier84017842sandier
spanner94312562spann_er
sunnier73412152sunnier
tangier83013902tangier
tanner63722282tann_er
tawnier10318462tawnier
tinnier72910142tinnier
vanner94215842vann_er
wanier93920682wa_nier
wanner94019622wann_er
wennier10318602wennier
zanier154314712za_nier

Search took 5 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 Filter1786911076710.376475242.0
2DLD Change Limit107671833.67029338.1
3Display Results83830.0332515.2
 (SQL Overall)178691834.07943807.6
 
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.