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 “perambulatory” with Change Limit: [1] [2] [3] [4] [5] [6]

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

58 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
perambulatory226178(None) 
perambulator1862091perambulator_
perambulators1961951perambulators
ambulatory1744403___ambulatory
perambulate1753763perambulat__e
perambulated1953053perambulat_ed
perambulates1853483perambulat_es
perambulating2052523perambulating
perambulation1953483perambulation
perambulations2053073perambulations
ambulator1346164___ambulator_
ambulators1445474___ambulators
ejaculatory2352984_eja_culatory
gratulatory1553204_gra_tulatory
precopulatory2261844precopulatory
preovulatory2052194p_reovulatory
adulatory1346315___a_dulatory
ambulatorily1961365___ambulatorily
articulatory1754905_articulatory
circulatory1854625cir__culatory
confabulatory23122275confabulatory
defamatory1943485defam___atory
ejaculator1944135_eja_culator_
ejaculators2043625_eja_culators
emasculator1553235_emasculator_
emasculators1652775_emasculators
emulator1048745_e__m_ulator_
emulators1148185_e__m_ulators
fabulator1445395__fa_bulator_
fabulators1544695__fa_bulators
formulator1564585for_m_ulator_
formulators1684235for_m_ulators
gesticulatory1952615gesticulatory
granulator1155105_gra_nulator_
granulators1244615_gra_nulators
paramilitary1961775param_ilitary
peculator1387865pe___culator_
peculators1486985pe___culators
percolator1445915per__colator_
percolators1545365per__colators
peremptory1953115perem___ptory
performatory2252585per_formatory
perfunctory2151665per__functory
permeator1347405per_m__eator_
permeators1447405per_m__eators
perpetuator1552725perpetu_ator_
perpetuators1652665perpetu_ators
persecutory1852625persecu__tory
perspiratory1952965per_spiratory
probatory1647115p_r_ob__atory
promulgator1652025p_rom_ulgator_
promulgators1751935p_rom_ulgators
regulatory1445295__r_egulatory
stimulatory1663915_stim_ulatory
stridulatory1652265str_idulatory
tabulator1145925__ta_bulator_
tabulators1245295__ta_bulators
translatory1454805_tra_nslatory

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 Filter1786911247900.406440125.6
2DLD Change Limit124790588.46614740.1
3Display Results58580.0331757.6
 (SQL Overall)178691588.90520066.4
 
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.