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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

107 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
blintze183390(None) 
blintz1788841blintz_
blintzes1944261blintzes
blite76225352bli_t_e
blithe115810862bli_the
blitz165318132bli_tz_
blitzed19336532bli_tzed
blitzer18447662bli_tzer
blitzes18408702bli_tzes
absinthe1342643absinthe
aline57243153alin__e
baize164717393bai__ze
belittle1044053belittle
bhistie1236773bhistie
binate8419773b_inate
bindle94516263b_indle
bine66650863b_in__e
binge85125513b_in_ge
bint67355043b_int__
bints76130183b_int_s
bistre83815023b_istre
bite66547003b_i_t_e
bize155926293b_i__ze
blastie92411393blastie
blate75933783bl_at_e
blaze165520833bl__aze
blende95413443blen_de
blent76230953blent__
blin67228173blin___
blind86319323blin__d
blindage1243683blindage
blinded114810023blinded
blinder103912983blinder
blindly1335743blindly
blinds95111613blin_ds
blini75519273blin__i
blinis85313683blin_is
blink115720143blin__k
blinked144010013blinked
blinker134110213blinker
blinks124613573blin_ks
blister94415313blister
blites84721213bli_tes
blither124812173bli_ther
blitzers19417153bli_tzers
blonde94813293blon_de
blunge94311483blun_ge
blunt75525023blunt__
blunted104210663blunted
blunter94512033blunter
bluntly1235223bluntly
blunts84512893blunt_s
boite74426323boi_t_e
bonze165119353b_on_ze
brindle104210103brindle
brine75132273brin__e
bristle91910103bristle
brittle9168603brittle
bronze173610923bron_ze
byline11311643bylin__e
chintz204212033chintz_
chintzes2235973chintzes
chintzy24364223chintzy
cline76428533clin__e
elint55436473elint__
elints65816423elint_s
elite56230183eli_t_e
flint87333503flint__
flinted114411893flinted
flintier1136393flintier
flints95617453flint_s
flinty126112493flint_y
flite85424963fli_t_e
glint66830183glint__
glinted9399373glinted
glintier945703glintier
glints75714213glint_s
glinty106910693glint_y
glitz154916373gli_tz_
glitzed18375493gli_tzed
glitzes17367563gli_tzes
glitzy19404783gli_tzy
linage7713403_linage
line46965573_lin__e
lint416266233_lint__
linted74021823_linted
lintel64013993_lintel
linter64625343_linter
lintier73613803_lintier
lintol6369473_lintol
lints57137193_lint_s
linty87126563_lint_y
lionize1668823_lionize
listee64223063_listee
lite47054543_li_t_e
lithe84922013_li_the
litre55421463_li_tre
little63312163_little
pintle83818263_pintle
plinth11310453plint_h
plinths1236123plinths
pointe84619313point_e
quinte153414523quint_e
salinize1739683salinize
slainte738543slaint_e
wintle94014603_wintle
winze175014853_win_ze

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271076.93619323.4
3Display Results1071070.0333242.4
 (SQL Overall)1786911077.37524229.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.