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

80 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
practitioners176157(None) 
practitioner1651891practitioner_
partitioners1452642p_artitioners
partitioner1353453p_artitioner_
petitioners1353433p__etitioners
actioners1147734__ac__tioners
malpractitioner2110544malpractitioner_
partitioned1453504p_artitione_d
partitions1248334p_artition__s
petitioner1244154p__etitioner_
practicalness1953324practicalness
practicers1663594prac__ti_cers
probationers1662574pr_obationers
proctitides1664724proctiti_de_s
proctitises15106324proctiti_se_s
provisioners1752814pr_ovisioners
vacationers1652484_vac_ationers
actioner1048665__ac__tioner_
brachiations19193525brachiation__s
brattiness1255845bra_t_ti_ness
cautioners1244735___cautioners
conditioners1563925_conditioners
eructations1347235eructation__s
executioners2172195exec_utioners
exhibitioners2561595exhibitioners
factitious1544085_factitio__us
factitiousness1994305_factitiousness
fractioned1644615frac__tione_d
fractions1449105frac__tion__s
fractiousness1856875fractiousness
gratifiers1443865gra_tifi__ers
jactations1936895_jactation__s
lactations1239425_lactation__s
pacifiers1645475p_ac_ifi__ers
pactions122613505p_ac__tion__s
parishioners1751555p_arishioners
parotitises1346435parotiti_se_s
partition1148695p_artition___
partitioning1552975p_artitioning
partitionist1456265p_artitionist
partitionists1554765p_artitionists
partitives1546635p_artiti_ve_s
petitionary1653765p__etitionary
petitioned1344175p__etitione_d
petitions11511085p__etition__s
placations1438585plac_ation__s
plantations1347475plantation__s
plasticines15105435plastici_ne_s
plasticizers2592395plastici_zers
portioners1257425p___ortioners
practicer1544595prac__ti_cer_
practices1557995prac__ti_ce_s
practicing1775585practici_n__g
practises1349625prac__ti_se_s
practising1586365practisi_n__g
pratincoles1552485pra_tincole_s
prattlers11195335pra_t_t__lers
precautionary2062265precautionary
precautions1546555precaution__s
precisions1449375prec_ision__s
prettifiers1642515pr_et_tifiers
prettiness1257395pr_et_ti_ness
prisoners1147375pr___i_soners
proactions1449345proac__tion__s
probationer1563775pr_obationer_
proctitis1348375proctiti____s
provisioner1653795pr_ovisioner_
punctations1585355punctation__s
rachitides1644535_rachiti_de_s
ratifiers1236455_ra_tifi__ers
ratooners965845_ra___tooners
ratteners9237275_ra_t_t_eners
rectifiers1545175_rectifi__ers
stationers1044765___stationers
tractions11511625trac__tion__s
traditionary1663155tra_ditionary
traditionless1462095tra_ditionless
traditions1147205tra_dition__s
transitions1148925transition__s
vacationer1543305_vac_ationer_

Search took 10 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.390458182.1
2DLD Change Limit124790809.20313559.7
3Display Results80800.0461739.1
 (SQL Overall)178691809.63918538.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.