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

67 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
semises9391655(None) 
demises103719561demises
remises93423481remises
seises64026711se_ises
semioses10611011semioses
aegises8311372aegises
bemires113212832bemires
bemists113410702bemists
bemixes18338652bemixes
bemuses1139292bemuses
betises94816122betises
camises114218462camises
cerises94722252cerises
chemises153211982chemises
demies94825802demi_es
demise94618322demise_
demised113613682demised
demoses103815832demoses
dermises112512022dermises
devises114116762devises
egises7312492_egises
emeses86114962_emeses
itemises1087692itemises
kermises14248312kermises
lewises1039132lewises
merises93421422merises
mises74740562__mises
nemeses948662nemeses
peises84125042pe_ises
penises9318192penises
premises123018272premises
remiges103015472remiges
remise84221952remise_
remised103516842remised
remiss84216352remis_s
remixes164313872remixes
rerises73525882rerises
revises104220532revises
samisen937672samisen
samisens1035482samisens
samites93118712samites
seines65029902se_ines
seise54727852se_ise_
seised74218122se_ised
seiser65318342se_iser
seisers73816392se_isers
seisms84912142se_isms
seizes154317532se_izes
sememes11109202sememes
semes75731582sem__es
semiosis1059872semiosis
semis74623532semi__s
seniles72618022seniles
senses63923942se_nses
sepses84515882se_pses
series64540972seri_es
serines74229542serines
sexisms16226222sexisms
sexists14267672sexists
similes92915232similes
sises55233832s__ises
smiles84522292s_miles
smites83921922s_mites
somites94219122somites
speises93813932speises
surmises10310642surmises
tamises92715972tamises

Search took 4 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 Filter1786911076710.373479064.3
2DLD Change Limit107671673.14334257.4
3Display Results67670.0135153.8
 (SQL Overall)178691673.52950635.0
 
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.