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

95 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
abscise114595(None) 
abscised1364131abscised
abscises1246231abscises
abscess1133902abscess
abscisin1243972abscisin
abscissa1261592abscissa
abscissae1361352abscissae
abacas104414723abacas_
abaci94718843abaci__
abacus10349763abacus_
abacuses1235763abacuses
abase76023483ab__ase
abatis84317933abatis_
abatises10311013abatises
abaxile1644083abaxile
abbacies1445483abbacies
abide86223713ab__ide
ableism1136823ableism
ableist9311773ableist
abolish12311503abolish
abris75722603ab_ris_
abscessed1442703abscessed
abscesses1344103abscesses
abscising1444943abscising
abscisins1343593abscisins
abscissas1361563abscissas
abscond1244503abscond
abseil837183absei_l
abseiled1144733abseiled
abseils935973abseils
absence1137713absence
absolve1244513absolve
abstruse1065513abstruse
abuse77119563ab__use
abusive1245283abusive
accuse103411033a_ccuse
advise10139223a_dvise
agonise83112693agonise
airwise1036713airwise
alsike1047913als_ike
anise55129703a__nise
anywise1345203anywise
apprise11310193apprise
apsis75718293aps_is_
arcsine94512393arcsine
arise56436433a__rise
arsine64021043ars_ine
arsis55722423ars_is_
asceses938623a_sceses
asci66519143a_sci__
ascites9312603a_scites
ascribe1147743a_scribe
ascus75013583a_scus_
aside65122083a_s_ide
aspire8612123a_spire
aspis74618143a_spis_
aspises9611643a_spises
aspish114810333a_spish
assais6711963assais_
assist6314603a_ssist
assize1538633a_ssize
asslike1137373asslike
atomise93013823atomise
auspice1136523auspice
azotise1637073azotise
baptise1139553baptise
bascule1136573bascule
basics104915123basics_
basis75429863bas_is_
bassist9312743bassist
bastile9313913bastile
betise85616273_betise
bise66437103_b__ise
braise84318753_braise
bruise83412873_bruise
concise11314473concise
despise1038683despise
discase102912863discase
ebonise939613ebonise
excise1538553_excise
fasciae1247523fasciae
fascine12510583fascine
fascism1436443fascism
fascist1239213fascist
incise83515333_incise
laicise939333laicise
miscite11314383miscite
obelise9310173obelise
obscene1145243obscene
obscure1145333obscure
oscine8311563_oscine
piscine11610973piscine
precise113518173precise
seise54727853__seise
viscose1237863viscose

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 Limit134027957.20318607.1
3Display Results95950.0462065.2
 (SQL Overall)178691957.65523343.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.