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

44 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
pistolier114638(None) 
pistoleer1144311pistoleer
pistoliers1244581pistoliers
epistoler1143742epistol_er
pistole92414312pistol_e_
pistoled11259592pistol_ed
pistoleers1243792pistoleers
pistolero1163632pistol_ero
pistoles102514722pistol_es
pistoling1268492pistoling
pistolled1255162pistolled
bristlier1144313brist_lier
costlier1038523cost_lier
dissolver1345623dissolver
distiller1046663distiller
distorter1048403distorter
epistler1044833epist_l_er
epistolers1243183epistol_ers
gasolier935833gas_olier
gristlier1044283grist_lier
historied1347773historied
histories12412473histories
mistier93418713mist__ier
pastier94320383past__ier
pestier94317403pest__ier
pimplier1445413pi_mplier
pisolite10310373pis_olite
pisolites1149383pis_olites
pisolith1346553pis_olith
pissoir945043pisso_i_r
pistol83313333pistol___
pistoleros1262853pistol_eros
pistolling1345353pistolling
pistols93213983pistol__s
pitchier15368273pi_tchier
pithier123010293pi_t_hier
pitier84019823pi_t__ier
pontonier1146383pontonier
portlier1038373port_lier
priestlier1242883priest_lier
stolider936603__stolider
stonier72013793__stonier
thistlier1243653thist_lier
wiselier1137363wis_elier

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 Filter1786911486410.423422437.4
2DLD Change Limit148641446.56322648.3
3Display Results44440.0162750.0
 (SQL Overall)178691447.00225520.0
 
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.