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

54 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
piscator124692(None) 
piscators1347081piscators
piscatory1645271piscatory
picador1245922pi_cador
bisector1245193bisector
citator9310123ci_tator
dictator1147263dictator
dilator82712793di_lator
discolor1146423discolor
disfavor1542873disfavor
educator1147153educator
epilator1049243epi_lator
evocator1346573evocator
isolator847533_isolator
lictor83610863li_c_tor
locator93110423_locator
migrator1147873migrator
miscolor1245603miscolor
mislabor1244503mislabor
mistutor1044943mistutor
nitrator849553nitrator
palpator1247133palpator
pastor84817483pas__tor
picadors1345853pi_cadors
picaro10311323pi_caro_
picaros11310893pi_caros
piccata1345703piccat_a
piscary1437423pisca_ry
piscatorial1553293piscatorial
pisciform1843253pisciform
piscivore1652363piscivore
pisco96314983pisc__o_
piscos105112593pisc__os
pistol83313333pis__tol
piston83515923pis__ton
pistou83211843pis__tou
placater1238013placater
placatory1645723placatory
precatory1649113precatory
predator11310053predator
proctor11310433proc_tor
pronator10311783pronator
pulsator1085693pulsator
spiccato1463183spiccato_
spiccatos1553253spiccatos
stator64015483__stator
testator847373testator
titrator858543titrator
viator93211833vi__ator
vibrator13227343vibrator
victor113210673vi_c_tor
violator1146283violator
visitor1046203vis_itor
vitiator1147043vitiator

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 Filter1786911461620.436409841.7
2DLD Change Limit146162547.92318447.8
3Display Results54540.0134153.8
 (SQL Overall)178691548.37221343.9
 
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.