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

133 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
achiral1210918(None) 
chiral114614411_chiral
actinal9312292actinal
admiral1046362admiral
archival1645782archival
awhirl1264672awhir_l
chital114313882_chital
choral115118492_choral
rachial122012172rachi_al
aboral8314373a_boral
acaudal1045773acaudal
accrual1144553accrual
accusal11136003accusal
acetal84314903ac_etal
achenial1348283achenial
achier113914263achi_er
achiest12315183achiest
achieve1545023achieve
aching126521973achi_ng
achingly1736613achingly
achiote1239213achiote
acinar8310483ac_inar
actual8311023ac_tual
admirals1144353admirals
aecial84817313aeci_al
aerial64625713aeri_al
affinal1336443affinal
affixal2043763affixal
albinal937813albinal
amoral8314623a_moral
amphoral1565623amphoral
anginal8310163anginal
animal85016253a_nimal
antheral1149393antheral
antral65719413a_ntral
anural65714743a_nural
apical10913903a_pical
apsidal1046693apsidal
apteral9311523apteral
arbitral1045423arbitral
archaeal13115463archaeal
archaical1645903archaical
archil11611573archi__l
archrival1743383archrival
arrhizal2042943arrhizal
arrival1037563arrival
ashram1139053ash_ram
ashtray13805553ashtray
astral66919283a_stral
aswirl935093aswir_l
athirst1037873athirst
atrial65418943atri_al
audial7312993audi_al
augural856403augural
aural54428963a__ural
auroral7310473auroral
austral73411513austral
axial124515193a_xi_al
bharal1138893_bharal
brachial15219303brachi_al
cameral11311263cameral
capital112311523capital
caporal11410943caporal
carinal94318223carinal
charas114223593_charas
chia96026623_chi_a_
chiao105618363_chi_ao
chias104625513_chi_as
chica125818263_chica_
chicas135916463_chicas
chiel104918973_chi_el
chill105619873_chi_ll
chimar133911463_chimar
chimla1337593_chimla
china105022473_china_
chinas115119383_chinas
chirk144516183_chir_k
chirks155414843_chirks
chirm125317063_chir_m
chirms135113983_chirms
chiro105320343_chir_o
chiros114617773_chiros
chirp124717163_chir_p
chirps135414003_chirps
chirpy16498913_chirpy
chirr105015903_chir_r
chirre114111853_chirre
chirrs114514983_chirrs
chiru105317153_chir_u
chirus114615693_chirus
chisel112111943_chisel
chloral12169983_chloral
chorale124313353_chorale
chorals124614103_chorals
chordal13449883_chordal
choreal124412223_choreal
chorial124214143_chorial
churl105913883_chur_l
citral81113883_citral
clinal8311553_clinal
coital84117053_coital
coral76033453_c_oral
corral83616253_corral
crural8610633_crural
curial84019153_curial
ephoral1248403ephoral
ethical1238443ethical
facial113615633fac_i_al
horal86328673__horal
ischial1246423ischi_al
kachina1637663kachina_
kachinas1736333kachinas
lacrimal1244443lacrimal
lochial1257083lochi_al
macrural1244953macrural
nadiral836343nadiral
phial10313203_phi_al
rachilla1345713rachilla
racial83419243rac_i_al
rhinal9510183_rhinal
sacral83414413sac__ral
sahiwal1344443sahiwal
schorl1179803schor_l
scleral937863scleral
scribal1137963scribal
spheral1238423spheral
spiral83715343_spiral
tactical1248843tactical
thiram1139943_thiram
thirl85416823_thir_l
vaccinal1544903vaccinal
viral86419593__viral
whirl114913823_whir_l

Search took 7 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.1561145455.1
2DLD Change Limit1340271336.64020184.8
3Display Results1331330.0502660.0
 (SQL Overall)1786911336.84626101.5
 
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.