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

78 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
puberty144478(None) 
liberty1237162liberty
poverty1536432poverty
puberal1147772puberal
pubertal1254322pubertal
purty105019402pu__rty
ambery133811133amber_y
auberge1045633auberge
berry104521773__berry
berth104917883__berth
borty105522833__borty
cherty144612473_cherty
cuber95222533cuber__
cubers105318353cuber_s
daubery13396213dauber_y
dubiety1344583dubiety
dupery12378743duper_y
lubberly1543663lubberly
lumberly1544683lumberly
mulberry1542563mulberry
papery134812743paper_y
party106630613p__arty
peaty105725693p__eaty
peery105719443p_eer_y
perdy115417333p__erdy
perky145319483p__erky
perry105222713p__erry
pert66759323p__ert_
pertly115312553p__ertly
pesty106421713p__esty
petty105320293p__etty
piety105817303p_ie_ty
pinery115214293piner_y
plenty11311413p_lenty
plumbery17315533plumber_y
poetry1139383p_oetry
popery134511703poper_y
prepuberty1951763prepuberty
pretty11510873p_retty
property1547073property
prudery1335243pruder_y
puberties1346603puberties
pubes94423403pube__s
puckery18306263pucker_y
pudency1544763pudency
puffery18235113puffer_y
puggry13374823puggr_y
puler74826623puler__
pulers83820283puler_s
punty106021613pu__nty
puppetry1442503puppetry
purely114013633pure_ly
purer75127903purer__
purest84021933purest_
purity114114913pu_rity
pursy105016413pu__rsy
putrefy1543313putrefy
putty104721403pu__tty
queerly1934233queerly
query174212083qu_er_y
qwerty2133583_qwerty
rubbery14337593rubber_y
rudery10419033ruder_y
soberly1236943soberly
subentry1344693subentry
suber74924503suber__
suberic11312213suberic
suberin9314563suberin
subers85722643suber_s
subvert12312893subvert_
subverts1336973subverts
suety85318493su_e_ty
surety93515013sure_ty
tuber75420683tuber__
tubers85017033tuber_s
ubiety1135913_ubiety
upbeat10911513upbeat_
upbeats1195733upbeats

Search took 7 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 Filter1786911340270.406440125.6
2DLD Change Limit134027786.14021828.5
3Display Results78780.0164875.0
 (SQL Overall)178691786.56227231.2
 
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.