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

84 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
flintiness134589(None) 
daintiness1145962daintiness
faintness1235832faint_ness
feistiness1345072feistiness
flightiness1843892flightiness
flimsiness1543452flimsiness
flintiest1248432flinti_est
flintinesses1546322flintinesses
slinkiness1445152slinkiness
bittiness11228333_bittiness
blindness1235343blin_dness
bluntness1144343blunt_ness
brininess1138203brin_iness
dinginess1137823_dinginess
dirtiness1039473_dirtiness
faintishness1863063faintishness
fanciness1437673f_anciness
fattiness12239373f_attiness
faultiness1344823faultiness
fieriness1238623f_ieriness
filminess1435983f_ilminess
filthiness1643713filthiness
fineness11310643f_in_eness
finiteness1347113f_initeness
fishiness1537343f_ishiness
fitness10299393f_i_t_ness
flabbiness1742523flabbiness
flakiness1636473fl_akiness
flashiness16105283flashiness
flatness1138153fl_at_ness
fleetness1244753fleet_ness
fleshiness16104293fleshiness
flinkites1643483flinkite_s
flintier1136393flinti_e_r
flinting123412343flintin__g
flirtiest1236193flirti_est
floppiness1742863floppiness
fluffiness1542603fluffiness
flukiness1635453fl_ukiness
franticness1643603franticness
friskiness1744453friskiness
frizziness2142713frizziness
frostiness1336563frostiness
fruitiness1345993fruitiness
funkiness16226873f_unkiness
funniness12256533f_unniness
fustiness121910243f_ustiness
glintiest1037623glinti_est
grittiness1145163grittiness
guiltiness1144193guiltiness
inkiness1238693__inkiness
intines7921113__intine_s
jauntiness1743973jauntiness
kinkiness1235763_kinkiness
lankiness1338053_lankiness
licitness1145373_licitness
liminess10510643_li_miness
lintiest82715913_linti_est
lintless82710013_lint_less
lippiness1335413_lippiness
liteness82213213_li_teness
loftiness1236573_loftiness
lustiness92010453_lustiness
mistiness111911633_mistiness
niftiness1236363_niftiness
pliantness1263643pliant_ness
raininess949273rain_iness
runtiness92410393_runtiness
saintliness1144153saintliness
scantiness1236883scantiness
shiftiness1644793shiftiness
shininess1237333shin_iness
skinniness1443313skinniness
slanginess1146273slanginess
slatiness92511363sl_atiness
sliminess1137423sli_miness
spininess1137963spin_iness
stinginess1145953stinginess
tininess8310633_tin_iness
tinniness936093_tinniness
whininess1535123whin_iness
windiness1337373_windiness
wintriness1345543_wintriness
wittiness12197223_wittiness

Search took 8 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 Filter1786911406030.403443402.0
2DLD Change Limit140603846.61021271.3
3Display Results84840.0332545.5
 (SQL Overall)178691847.04625360.6
 
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.