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

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

75 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
probationer156377(None) 
probationers1662571probationers
probation13412182probation__
probational1547082probational
probationary1953222probationary
probations14311082probation_s
portioner1158693p_o_rtioner
probating14311193probati_n_g
probative1649173probati_ve_
pronation11415703pronation__
pronations12314033pronation_s
proration11415983proration__
prorations12314463proration_s
provisioner1653793provisioner
approbation1755024approbation__
approbations1854244approbation_s
lobation102110554_lobation__
lobations11219614_lobation_s
motioner1037594_mo__tioner
obtainer1045794__obtai_ner
partitioner1353454partitioner
peroration12316004peroration__
perorational1446394perorational
perorations13314064peroration_s
petitioner1244154p_etitioner
phonation1439394phonation__
phonations1538314phonation_s
portioned1248344p_o_rtioned
portioners1257424p_o_rtioners
positioned1396004p_ositioned
postponer1346034p_o_stponer
potation101716784p_otation__
potations111615074p_otation_s
practitioner1651894practitioner
predation12313464predation__
predations13812154predation_s
preobtained1652764preobtai_ned
privation14311174privation__
privations15310104privation_s
proaction13410104proaction__
proactions1449344proaction_s
probate11414484probat___e_
probated13410864probat___ed
probates12414284probat___es
probationally2054094probationally
probatory1647114probat_o_ry
probities13312654probiti__es
procaine12312274proca_i_ne_
procaines13311524proca_i_nes
profaner13197944profa___ner
prolamine131510564prolami_ne_
prolamines14159364prolami_nes
promotion1359504promotion__
promotional1555634promotional
promotions1448784promotion_s
pronating12313764pronati_n_g
pronator10311784pronat_o__r
pronatores1247374pronat_ores
proportioned1754404proportioned
prorating12314284prorati_n_g
protamine131310914protami_ne_
protamines14149804protami_nes
provisioned1753974provisioned
provisioners1752814provisioners
rationed9410094_r__ationed
ratooner887004_r__atooner
reprobation1548504reprobation__
reprobations1647774reprobation_s
rogation91612054_rogation__
rogations101510824_rogation_s
rotation81615454_rotation__
rotational1048094_rotational
rotations91613844_rotation_s
stationer946034__stationer
vacationer1543304_vacationer

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 Filter1786911488190.440406115.9
2DLD Change Limit148819758.87316772.1
3Display Results75750.0332272.7
 (SQL Overall)178691759.34619119.5
 
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.