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

79 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
saintlier95462(None) 
auntlier834902_auntlier
daintier937402daint_ier
gainlier965672gain_lier
paintier1048792paint_ier
saintliest1046012saintliest
saintlike1344782saintlike
spindlier1253872spindlier
antler64615553_a_ntl_er
antsier7410773_a_ntsier
bairnlier1142233bairnlier
bristlier1144313bristlier
chintzier2342663chintzier
crinklier1543843crinklier
dainties9312403daint_ies
danglier1056753da_nglier
fainter103611053faint__er
flintier1136393flint_ier
ganglier1047603ga_nglier
glintier945703glint_ier
gristlier1044283gristlier
inlier63615363__in_lier
janglier1656113ja_nglier
jauntier1535233jaunt_ier
jinglier1655233_jinglier
kindlier1345763_kindlier
kinglier1345633_kinglier
lintier73613803_lint_ier
mainliner1144673main_liner
maintainer1243513maintainer
manlier92414023ma_n_lier
mintier93615993_mint_ier
painter93814563paint__er
pointier1038303point_ier
rainier71614263rain__ier
sailer63526103sai__l_er
sainted84114243saint__ed
sainting93215733saint_ing
saintliness1144153saintliness
saintly1039343saintl__y
sallier73320423sa__llier
saltier74318633sa_lt_ier
sandier84017843sa_n_dier
sanities81219773sanit_ies
sanitizer18126733sanitizer
santir6315253sa_nt_i_r
saunter72913453saunt__er
saunterer945033saunterer
scantier10309983scant_ier
shiftier1436343shift_ier
shingler12268633shingl_er
shinier104113143shin__ier
shirtier1137943shirt_ier
shittier1137313shi_ttier
sicklier1457213s_icklier
sightlier1344453sightlier
sillier74017593s_i_llier
siltier73413863s_ilt_ier
sinter63625923s_int__er
skinnier1264893skin_nier
slinkier12206933slin_kier
slittier837003sli_ttier
spanglier1244193spanglier
spindler11297983spindl_er
spinier93715163spin__ier
squintier1844473squint_ier
stillier868823sti_llier
stingier9279123stin_gier
stinkier12278543stin_kier
stinter73614513stint__er
swindler12257723swindl_er
swingier12267003swin_gier
swirlier1135213swi_rlier
tanglier948073ta_nglier
thistlier1243653thistlier
tinglier956403_tinglier
tinklier1255443_tinklier
wintrier1136873_wintrier
wrinklier1643013wrinklier

Search took 9 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 Filter1786911486410.410435831.7
2DLD Change Limit148641797.95018697.0
3Display Results79790.0332393.9
 (SQL Overall)178691798.39321290.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.