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

100 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
lexis12591603(None) 
leis45739601le_is
lenis56326861lenis
levis85818551levis
lewis85315841lewis
lexes127225261lexes
aegis6316782aegis
alexia132910462alexia
alexias14249792alexias
alexin132311482alexin
alexins141910662alexins
axis116127912_axis
cedis84317082cedis
clevis1158962clevis
defis96717502defis
deixis1437242deixis
delis64928542delis
dexes135224512dexes
dexie134716892dexie
dexies145018342dexies
egis56520652_egis
elemis8312382elemis
exes116530812_exes
exist124618942_exist
exit114428672_exit
exits125515912_exits
flexes164512952flexes
hexes155123042hexes
ilexes134510252ilexes
kepis115313362kepis
kexes166216812kexes
lapis76223152lapis
laris54737462laris
laxes125430092laxes
leads66028492leads
leafs85721182leafs
leaks95923912leaks
leans55536252leans
leaps75522932leaps
lears55938732lears
leas45954182le_as
leeks95318892leeks
leers54828982leers
lees45455882le_es
leets54927122leets
lefts86517812lefts
leges64427282leges
legist71315252legist
legit61323502legit
legits71313002legits
legs56133692le_gs
lehrs86111132lehrs
lei36846382le_i_
leks85427602le_ks
lends65326252lends
lenes54738522lenes
lenos56024862lenos
lens46146492le_ns
les35663072le__s
leses54930812leses
less45635102le_ss
lets47147942le_ts
leuds66214812leuds
levies93919862levies
levin84816412levin
levins94514652levins
lex107943822lex__
lexica1536102lexica
leys76430182le_ys
lis37162272l__is
loris55329152loris
louis57322322louis
loxes125227472loxes
luxes124921502luxes
lweis8458692lweis
lysis84511462lysis
maxis145721562maxis
metis75025902metis
nexus124710662nexus
penis75129322penis
peris75537072peris
plexes155313532plexes
plexus15377282plexus
pyxis17458632pyxis
reis45343232re_is
rexes124526952rexes
seis45542392se_is
semis74623532semis
sexes126126222sexes
sexism15227652sexism
sexist133013482sexist
sexts125118382sexts
taxis126821972taxis
texas126514932texas
texts125515042texts
vexes155719122vexes
vexil1538962vexil
vexils1647172vexils
xis106935332__xis
yetis85418392yetis

Search took 2 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 Filter178691538000.0931921408.6
2DLD Change Limit538001001.81329674.6
3Display Results1001000.0333030.3
 (SQL Overall)1786911001.93992156.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.