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

95 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
paxwax174295(None) 
earwax1664732earwax
packwax2542852packwax
paxwaxes1942052paxwaxes
addax1435993_addax
alway116113923_alway
awa611939673_a_wa_
away108024223_a_way
axal116520493_ax_al
axial124515193_axial
axman144813183_axman
banjax2234763banjax
dewax165510853_dewax
fatwa1168063fatwa_
fatwas1249053fatwas
galax135314463ga_lax
handax1749583handax
hapax1739323ha_pax
jawan15710383ja_wan
narwal938943narwal
nawab10810923na_wab
paca85132243pa_ca_
pacas96029403pa_cas
pacha126518063pacha_
pachas135017143pachas
padnag1036073padnag
paean77222723pa_ean
paesan85114093paesan
pagan86121163pa_gan
paisa76021073paisa_
paisan84417073paisan
paisas84317493paisas
palea75028663palea_
paleae84820293paleae
paleal84716673paleal
palmar104113463palmar
palpal104112053palpal
pampa114913423pampa_
pampas124913993pampas
panchax2134983panchax
panda85022613panda_
pandas95521963pandas
panga85323543panga_
pangas99921113pangas
papa85827143pa_pa_
papal95820673pa_pal
papas94927493pa_pas
papaw125112493pa_paw
papaws13419113papaws
para65242173pa_ra_
parae76335703pa_rae
paras76143043pa_ras
pardah123412823pardah
pariah114320583pariah
parian83223963parian
parka115120883parka_
parkas125018023parkas
parkway1934553parkway
parlay113713993parlay
parral85517533parral
partan83820563partan
partway1535923partway
pascal10812373pascal
pasha105417183pasha_
pashas115117063pashas
pasta76624533pasta_
pastas85422873pastas
pathway1844853pathway
pausal81511963pausal
pavan106518473pa_van
paw87651173pa_w__
pawed115725613pa_wed
pawer104422973pa_wer
pawky173810153pa_wky
pawl95123263pa_w_l
pawls105617663pa_wls
pawn94625303pa_w_n
pawns108818133pa_wns
pawpaw1653503pawpaw
paws96038183pa_w_s
pax127346853p___ax
paxes144928423pax_es
payday1536613payday
pickax2135913pickax
poleax1547993poleax
pretax152310193pretax
prewar114712583prewar
prowar114110943prowar
psywar1443323psywar
rewax155713923_rewax
taxa116820093tax_a_
taxiway2043463taxiway
taxman15328613taxman
wax137041183___wax
woadwax2142173woadwax

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 Filter1786911127160.390458182.1
2DLD Change Limit112716956.22018121.5
3Display Results95950.0303166.7
 (SQL Overall)178691956.64026911.3
 
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.