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

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

61 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
plaint8532320(None) 
paint75443691p_aint
plain74823301plain_
plains85019591plains
plaints94012051plaints
plait75631571plai_t
plant75437111pla_nt
pliant83918821pliant
alant55742292ala_nt
blain75421792blain_
blains84516372blains
elain55324702elain_
elains64919852elains
elint55436472el_int
faint85837062_faint
flaunt9712912flaunt
flint87333502fl_int
glint66830182gl_int
haint85436322_haint
lain46146282_lain_
lint416266232_l_int
pain65647242p_ain_
pains75138282p_ains
paints85921832p_aints
painty114714752p_ainty
paling93530132paling
pant66061262p_a_nt
pint66963172p__int
placet103923672placet
placing123815282placing
plaice10311552plaice
plaid85118302plai_d
plaids94312442plaids
plained103812232plained
plainer93811982plainer
plainest10313612plainest
plainly1236472plainly
plaits83816472plaits
plan65833942pla_n_
plane74929142pla_ne
planet84228352planet
planing103418252planing
plank115221142pla_nk
plans75731272pla_ns
plants84921802pla_nts
plat66048872pla__t
platina94413642platina
plating103823072plating
playing133816092playing
plink115219122pl_ink
plinth11310452pl_inth
plying124312082plying
point75338732p_oint
print74837462p_rint
quaint15415172quaint
saint55147072_saint
slain54923572slain_
slainte738542slainte
slant55238702sla_nt
splint85223282spl_int
taint55542282_taint

Search took 3 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 Filter178691825510.340525561.8
2DLD Change Limit82551612.41034253.5
3Display Results61610.0302033.3
 (SQL Overall)178691612.78064277.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.